parseDate

Returns date from a string using a specified format.

Example

Convert TIMEIDString with format “dd/MM/yy” to type date.

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

Syntax

parseDate(string expr s_date, string mask)
  • s_date : expression evaluating to a string
  • mask : string describing format of s_date

    Returns

    date

Notes

This function takes in a string date representation to Convert it into an equivalent value of a date type in the same format as the given format_mask.