PQE formula using AND & OR

[mikeymay]

I am struggling to get the following formula to work when adding a column in the PQE
= if ([Theoretical Next Visit] = "" or [Theoretical Next Visit] < DateTime.LocalNow) and ([Next Visit] <> "" or [Next Visit] >= DateTime.LocalNow) then 1 else 0

Could somebody point out where this isn't working?

TIA

 

[Ozeroth]

Two problems I can see:

• DateTime.LocalNow should be DateTime.LocalNow()
• Rather than comparing datetime values with the empty string "", you may want to compare with null instead. It seems that this doesn't cause an error, but a datetime value will never be equal to ""

Regards,
Owen