Issue with Date Search on CM8

[popeye]

Hi,
we are using OpenWorkdesk in a Content Manager 8.4.3 environment => my date search is not working. When using the OpenWorkdesk date widget, the format of the date to be searched is "yyyy-MM-dd HH:mm:ss.S". The format required by Content Manager is "yyyy-mm-dd-HH.mm.ss.SSSSSS". I will be checking to see if a shorter version will work, for example, "yyyy-MM-dd" ==> but did you have this issue before? Can you help?

Thanks 🙂

[vahe]

The OpenWorkdesk support different time formats, also available for searches:
- TimeStamp (e.g. 06/28/2012 12.00)
- Date (e.g. 06/20/2012)
- Time (e.g. 10.20)
It is important to set the right datemode in the searchtemplate:

datemode=usetime|ignoretime|ignoredate‍

To search for the document Create Timestamp (creation date between date1 and date2) you have to use this in your searchtemplate:

<between>
   <whereprop datemode="usetime" editproperty="editable" symname="SYSROOTATTRS.CREATETS" />
   <literal />
</between>
‍‍‍‍‍‍

[popeye]

The "datemode" configuration solved the issue.

Thanks,
Popeye