Using Dates in Expressions (Concept)

Overview of Creating Expressions

Creating Expressions

Evaluating Properties

 

Autodesk Expression Builder > Creating Expressions For Geospatial Features > Creating Expressions > 

Using Dates in Expressions

Concept

Procedure

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