July 25, 2004, 12:24 PM
<ort>How to check if a DATE field has no value
Hi,
I'm trying to write an IF clause to check if a DATE field is empty (I don't want to print it in my report if it is empty).
I tried:
-IF TEST_DATE EQ . GOTO XXX
-IF TEST_DATE IS MISSING GOTO XXX
both potions don't work.
Any suggestions ?
July 26, 2004, 01:53 PM
<WFUser>Try IF TEST_DATE EQ 0. Dates are stored as numerics.