convert_date_time

The convert_date_time method converts date and time formats using standard IDOL formats. All date and time input is treated as local time unless it contains explicit time zone information.

The InputFormatCSV and OutputFormat arguments specify date and time formats, and accept the following values:

The following table shows some example date and time formats:

Date and time format string Example date
DD/MM/YYYY 09/05/2013
D+ SHORTMONTH YYYY 2 Jan 2001
D+ LONGMONTH YYYY HH:NN:SS ZZZZZ 17 August 2003 10:41:07 -0400

Syntax

convert_date_time( Input, InputFormatCSV, OutputFormat )

Arguments

Argument Description
Input (string) The date and time to convert.
InputFormatCSV (string) A comma-separated list of the possible date and time formats of the input.
OutputFormat (string) The format of the date and time to output.

Returns

(String). A string containing the date and time in the desired format.


_HP_HTML5_bannerTitle.htm