ParseDate

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

A date value that is either serial or UNIX, depending on the formatter specified, is returned. If the date cannot be parsed then an undefined value is returned. This can be tested with the ISUND function.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

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

Argument	Description
`DateString`	A date string.
`Pattern`	Pattern used for parsing dates. Refer to https://unicode-org.github.io/icu/userguide/format_parse/datetime for a complete list of format syntax. If an empty string is passed, then the format is determined by the locale based on the FormatterStyle and FormatterType parameters that were used with the NewDateFormatter function.
`Index`	Index returned by a call to the NewDateFormatter function. The default value is 0. If no date formatter exists at the index, then a default formatter is used as though it had been created with the following call: `NewDateFormatter('', 'Etc/UTC', 'serial', 'medium', 'date')`

Argument

Description

DateString

A date string.

Pattern

Pattern used for parsing dates.

Refer to https://unicode-org.github.io/icu/userguide/format_parse/datetime for a complete list of format syntax.

If an empty string is passed, then the format is determined by the locale based on the FormatterStyle and FormatterType parameters that were used with the NewDateFormatter function.

Index

Index returned by a call to the NewDateFormatter function. The default value is 0. If no date formatter exists at the index, then a default formatter is used as though it had been created with the following call:

NewDateFormatter('', 'Etc/UTC', 'serial', 'medium', 'date')

Example

nDate = ParseDate('2011/11/24', 'yyyy/MM/dd');