Search for Date (attribute) = blank

[ninhkieu1]

Hi... I need you guys help again. I am using Livelink 971. I am trying to search for Start Date and/or End Date attributes that have not been filled in. These Start and End dates are part of Category in a document. How do I specify the "blank" date in my Complex Query? Here is an example of what I wrote but is not working:

[qlregion "Attr_Start_Date"] = " " AND [qlregion "Attr_End_Date"] = 20110101

Notice I used " " to emphasize the blank for Start Date. What can I use to tell the search that I am interested in documents with Start and/or End dates equal blank (not filled in). Thank so much.

 

[ggriffit]

you may be better doing this via a LiveReport or WebReport as you can search the LLATTRDATA table to pull these out if you are just looking for a report on them.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/