TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​ParseDate

Available In



ParseDate parses a date string according to a formatter defined with the NewDateFormatter function. 


ParseDate (DateString, <Pattern>, <Index>)

DateString: A date string to be parsed

Pattern: Pattern used for parsing dates

Index: Index returned by a call to the NewDateFormatter function. If no date formatter exists, then this is called
  NewDateFormatter(”, ‘Etc/UTC’, ‘serial’, ‘medium’, ‘date’)

Video Demo

Use ParseDate on the date ‘2020-04-22’, according to the format ‘yyyy-MM-dd’.