Publié Sun, 05 Jan 2020 06:40:07 GMT par Frédéric Escudero
is it possible to search for an empty date field ?
If not, what is the XML syntax to search for a specific date ?
Here is the XML file I send with my request  (I have tried to send the date in UTC format too) :

        *Ecole du Sacre-Coeur*


I receive no result with that request, but I have results without the date condition.
Publié Sun, 05 Jan 2020 21:59:24 GMT par Frédéric Escudero
Well, I have the answer :
- Yes, you can perform a research on an empty date field using the EMPTY() keyword (tested).
- The search date syntax is correct, my DBName wasn't ;)
Publié Mon, 06 Jan 2020 16:03:55 GMT par Joe Kaufman Bell Laboratories Inc Senior System Architect

Good info! I did not know the EMPTY() keyword could be used (or else I did know a long time ago and forgot *smile*).

Just FYI for anyone else reading the thread, you can make the search be for a range of dates by simple adding a second "Value", like this:

This is a query on a field called "SHIP_DATE", and would get everything where ship date was in 2019.

For a full date/time field, such as DWSTOREDATETIME, the XML looks like:


This would get anything stored on January 3, 2020.

Incidentally, you can use the full date/time syntax on a field that is just a "date" type and it works fine. DocuWare stores Date and DateTIme fields the same way in the database (at least in SQL Server).

Joe Kaufman


You must be signed in to post in this forum.