Thanks for the fast reply, Allen.
Actually, I have it correct: I want to alert the user that the To date shouldn't be before the From date. For example, if the From Date is 2016-03-20 and the To date is 2016-03-10, I want the To field to highlight since its date is before the From Date.
If it helps to re-visualize the calc, you could restate it as: IsEmpty ( temp::DateTo ) < temp::DateFrom
I think your calculation is too tricky. The result of
IsEmpty ( date )
is boolean (true or false), so comparing it to date is meaningless.
If you need allowing empty of DateTo,
not IsEmpty ( temp::DateTo ) and temp::DateFrom > temp::DateTo
Ah! Perfect! THANK YOU!
I hadn't thought about the Boolean result when using IsEmpty. Love it when I learn something. : )