comparing "updated" field to a custom datetime field

[Alexander Pham]

I have a defined a custom field to store date time. The intent is to compare this field to the standard field "updated" in certain queries.

Search/JQL allows either field to compare to a date time string like "2013-03-04 18:15". (not sure why it does not take second - but that's another question)

However, when I have a comparison like updated >= "my datetime field" , I get a validation error:

Date value 'updated' for field 'my datetime field' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

Is there some other particular date time type I should use?

Or is there a JQL date time conversion function I can use?

TIA.

[codelab expert]

In this case I would activate SQL Logging in Jira. In the log file you can trace which statement is executed. There you will find a hint about date formats which are used during comparism.