What is the correct way of date comparison.
I’m trying to find documents last modified after 3 Nov 2003.

I tried all of the following:

<D:where>
<D:gt>
<D:prop><D:getlastmodified/></D:prop>
<D:literal>2003-11-03T08:00:0Z</D:literal>
</D:gt>
</D:where>

<D:where>
<D:gt
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xs=“XML Schema”>
<D:prop><D:getlastmodified/></D:prop>
<D:typed-literal xsi:type=“xs:dateTime”>2003-11-03T08:00:0Z</D:typed-literal>
</D:gt>
</D:where>

<D:where>
<D:gt>
<D:prop><D:getlastmodified/></D:prop>
<D:literal>Mon, 3 Nov 2003 08:16:37 GMT</D:literal>
</D:gt>
</D:where>

<D:where>
<D:gt
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:xs=“XML Schema”>
<D:prop><D:getlastmodified/></D:prop>
<D:typed-literal xsi:type=“xs:dateTime”>Mon, 3 Nov 2003 08:00:00 GMT</D:typed-literal>
</D:gt>
</D:where>

without success.
How do I do that?

Thanks
Guido

#API-Management
#Tamino
#webMethods

Hi,

currently your query is not possible :-(. The reason is:
according to http spec getlastmodified is formatted as one of:

• Sun, 06 Nov 1994 08:49:37 GMT ; RFC 822, updated by RFC 1123
  
• Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036
  
• Sun Nov 6 08:49:37 1994 ; ANSI C’s asctime() format
  

and so it is stored inside Tamino. As currently the property values are treated as strings, a query delivers not the expected result.

This issue is already addressed, a solution will be provided next version.

Regards,
Martin

#Tamino
#webMethods
#API-Management

Thanks for your response Martin,

I think I can live with that for the time being storing the dates redundantly (in custom properties) as milisecs since 1970.

Guido

#webMethods
#API-Management
#Tamino