Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to check if a DATE field has no value
Go
New
Search
Notify
Tools
Reply
  
How to check if a DATE field has no value
 Login/Join
 
<ort>
posted
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 ?
 
Reply With QuoteReport This Post
<WFUser>
posted
Try IF TEST_DATE EQ 0. Dates are stored as numerics.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to check if a DATE field has no value

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.