Frederic,
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:
2019-01-01
2019-12-31
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:
2020-01-03T00:00:00
2020-01-03T23:59:59
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).
Thanks,
Joe Kaufman