Built-in Functions → parseDate
parseDate() is a conversion function that returns date from a string using a specified format.
Signature
parseDate(string exp, string mask)
- string exp : an expression evaluating to a
string - string mask : a
stringdescribing the format of the string exp
Important
- The string mask value is case-sensitive.
- For a list of the supported date formats, refer to the Unicode Locale Data Markup Language (LDML).
- For details about how the Engine infers the date components, refer to Date inference logic.
Returns
date
Example
Convert TIME_ID_String with format "dd/MM/yy" to type date.
parseDate(INCORTA.sales.TIME_ID_String,"dd/MM/yy")