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.