Custom Column Help!

[BJW]

I have a column "Visit Date" and I need to create a custom column which will determine the following.

When Visit Date is Blank - then "Not Scheduled"

When Visit Date is less than today - then "Completed"

When visit date is greater than today - then "Scheduled"

I tried this, but I'm getting errors.

if [[Visit Date] <= DateTime.LocalNow() and [Visit Date]<> Null then "Completed",
else if [[Visit Date]> DateTime.LocalNow then "Scheduled",
else if [Visit Date]=Null then "Not Scheduled"

Anyone be able to assist in correcting my error?

thanks.

[jthomson · Accepted solution]

Don't know if null should be case sensitive or not, but I'd put seeing if it's null as the first stage of your logic, something like:

if [Visit Date] = null then "Not Scheduled" else if [Visit Date] > Date.From(DateTime.LocalNow()) then "Scheduled" else "Completed"