You can query on Date and Timestamp Properties by using RQL’s date
and timestamp
functions. These functions create date literals, which let you create RQL queries that compare a date or timestamp string to date or timestamp property values. These functions use the following formats:
date("yyyy-MM-dd")
datetime("yyyy-MM-dd HH:mm:ss zzz")
For example:
submittedDate > date("2009-10-22")
submittedDate > datetime("2009-10-22 16:08:45 EDT")