When cast to text, the output depends on the
jira.date.time.picker.java.format parameter set in your Jira instance.
19/Mar/20 would be returned for
dd/MMM/yy h:mm a
The allowed date-time format is defined at
Additionally you can use the formats allowed in JQL queries:
- yyyy/MM/dd HH:mm
- yyyy-MM-dd HH:mm
- or relative to current time using "w" (weeks), "d" (days), "h" (hours), or "m" (minutes).
If you want to return a number (a timestamp) instead, remove the leading % character in front of the field code.
You will not be able to do this in the basic mode. Learn more about Parsing modes.