{"id":10170,"date":"2016-02-25T09:51:58","date_gmt":"2016-02-25T01:51:58","guid":{"rendered":"http:\/\/localhost\/help\/p2-server\/calculations\/format\/"},"modified":"2024-01-17T10:48:02","modified_gmt":"2024-01-17T02:48:02","slug":"format","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/format\/","title":{"rendered":"Format()"},"content":{"rendered":"\n

Format<\/span><\/h2>\n

Format(Time ,FormatString [,TimeZone])<\/strong><\/p>\n

Returns<\/span><\/h2>\n

Formats the supplied time argument in the specified format.<\/p>\n

Inputs<\/span><\/h2>\n

Time<\/strong>: The time argument to be formatted.
\nBehaviour: Required
\nDimension: Collection, SingleValue, MultiCollection
\nValid\u00a0data types: DateTime, Decimal, Integer, String<\/p>\n

FormatString<\/strong>: The string specifying how to format the time.\u00a0
\nBehaviour:\u00a0Required
\nDimension: Collection, SingleValue
\nValid data types: String<\/p>\n

TimeZone<\/b>: The geographical or UTC offset time zone (e.g. \"Australia\/Perth\" or \"UTC+08:00\"). If not supplied, it assumes the configured calendar time zone.
\nBehaviour: Optional
\nDimensions: SingleValue
\nValid data types: String<\/p>\n

How to format data types<\/a><\/p>\n

Format Codes<\/h2>\n

The following codes within the FormatString are replaced with the relevant information. The codes are not case sensitive.<\/p>\n