NewDateFormatter function for IBM Planning Analytics (TM1)
NewDateFormatter sets the date format used with ParseDate and FormatDate function.
In this video, NewDateFormatter will be used to get today’s date and time and convert it to Chicago and Melbourne time.
Where can the NewDateFormatter function be used?
TurboIntegrator
Which TM1 Server version is the NewDateFormatter function available for?
Version 11 and 12
What is the syntax for NewDateFormatter?
NewDateFormatter(Locale, TimeZone, UnixTime, FormatterStyle, TimeType)
- Locale = local language
- TimeZone = time zone
- UnixTime = whether use Unix time or not
- FormatterStyle = date format whether ‘full’, ‘long’, ‘medium’ or ‘short’
- TimeType = type format whether ‘time’, ‘date’ or ‘datetime’
Relevant Functions
- FormatDate = Formats a date value
- NewDateFormatter = Sets the date format used with ParseDate and FormatDate function
- ParseDate = Parses a date string according to a format defined with the NewDateFormatter function.