Focal Point
Filter on Missing Date

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/2631051872

March 28, 2008, 04:49 PM
LaRev
Filter on Missing Date
PMF Version 2.6

How do I create a filter in PMF on a date that is blank or in SQL table?
Example- I want to create filter where "review date" is "" which means that a case is still open?
March 28, 2008, 10:39 PM
Bob Jude Ferrante
Remember you're talking about WebFOCUS. The WebFOCUS documentation has the information you seek.

MISSING is the keyword that searches for missing values. You can test for it.

WHERE [MY_DATE_FIELD] EQ MISSING would be the test. MY_DATE_FIELD is, of course, replaced by the real name of your date field; in the PMF Loader Filters tab, you use the dropdown to select the field of course.

Don't put quotes around MISSING.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!