Compare a Date and a Dateformula type field

DarkHorse

Hello, I'd like to know how to compare a Date and a DateFormula type field. I do the following;

IF ......
AND ("Date confirm">0D) AND FORMAT("Lead Time Calculation">0D) THEN...

"Date confirm" is Date type and "Lead Time Calculation" is a Dateformula type. In Lead time I want to say that if is different from empy. How I do it?.
Thanks in advance.

Albertvh

Hi

do this

AND ("Date confirm">0D) AND (FORMAT("Lead Time Calculation") <> '') THEN

Hope this helps

Albert

DarkHorse

Yes!!, it works. Thank you very much for your help.

Albertvh

Glad it helped.