Convert a Text String Into a Date

To convert a text string into a date, you can use the Date function. For example:

the date of effect = Date("2022-10-01")

The text string in this function can be either a value or a non-Boolean attribute. If it is a value it must be in quotation marks.

Note: The only date format that can be used with this function is 'yyyy-mm-dd' regardless of the date format defined in the project settings.