Built-in Functions → parseDate

parseDate() is a conversion function that returns date from a string using a specified format.

Signature

Copy
parseDate(string exp, string mask)

• string exp : an expression evaluating to a string
• string mask : a string describing the format of the string exp

Returns

date

Example

Convert TIME_ID_String with format "dd/MM/yy" to type date.

Copy
parseDate(INCORTA.sales.TIME_ID_String,"dd/MM/yy")