You can use the following date options in your expressions:
- To convert a text property that contains date or time information into a date value, use the ToDate or ToString conversion options. See Conversion Options. These options support a variety of formats for the resulting date strings.
- To use standard date and time formats, use the Date-Time Operators.
When you insert a date-time property from the Get Values panel into your expression, that value uses a Date-Time operator. If you are an advanced user, you can also add one of these operators to an expression if you know its FDO syntax.
The Date-Time operators are parsed using the standard SQL literal strings:
- DATE 'YYYY-MM-DD'
- TIME 'HH:MM:SS[.sss]'
- TIMESTAMP 'YYYY-MM-DD HH:MM:SS[.sss]'