To convert a text string to a date string and change its format

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]'

1. Select the command for which you want to create an expression.
2. Select ToDate from Conversion.
3. In the ToDate function, do one of the following:
   • Within the parentheses, type a property name.
   • Click Property. In the Property list, select the property to convert.

     Select a text property that represents a date value.

   

   Convert a text string to a date string.

4. Optionally, specify the date format.
5. Specify any further conditions for the expression.

   For information about formulating an expression, see Overview of Creating Expressions.

   For help with any expression element, see Creating Expressions - Reference.

6. Click OK to apply the expression.