July 25, 2004, 12:24 PM<ort>
How to check if a DATE field has no value
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).
-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.