Focal Point
How to check if a DATE field has no value

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2911097331

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.