Using Date Time Fields

Date/Time fields (startDate, endDate, and attribute6 - attribute7) can appear any number of times within a filter expression.

No wildcards are supported.

If no hours, minutes, seconds or milliseconds are specified then the field adds the time and milliseconds as required by the operations being performed.

The following formats for date/times are allowed:

  • yyyy
  • yyyy-MM
  • yyyy-MM-dd
  • yyyy-MM-ddTHH
  • yyyy-MM-ddTHH:mm
  • yyyy-MM-ddTHH:mm:ss
  • yyyy-MM-ddTHH:mm:ss.SSS
  • yyyyTD
  • yyyy-MMTD
  • yyyy-MM-ddTD
  • yyyy-MM-ddTHHD
  • yyyy-MM-ddTHH:mmD
  • yyyy-MM-ddTHH:mm:ssD
  • yyyy-MM-ddTHH:mm:ss.SSSD

where D can be either of:

  • Z
  • <+|-><HHmm|HH:mm|HH>

For example: 

2010-03-03T23:45+01
2010-03-03T23:45+01:30
2010-03TZ
2010T-0100

The operators given in the table are used as follows:

<startDate | endDate> <operator> <date/time>

For example:

  • startDate >= 2010-05-23T14:25:10
  • endDate <= 2010-05-23T14:25:10Z
  • startDate > 2010-05-23T14:25:10.123
  • endDate < 2010-05-23T14:25:10.123Z