DateTimeConvert
- date/time format conversion

Date/Time
(AFL 2.90)


SYNTAX DateTimeConvert( format, date, time = Null )
RETURNS NUMBER or ARRAY
FUNCTION The function allows to convert from DateTime format to DateNum and TimeNum and vice versa.

format parameter controls the direction of conversion:

  • format = 0 - converts DateTime format to DateNum format, example

    mydatenum = DateTimeConvert( 0, DateTime() );// - this returns DateNum
    date argument should be in datetime formattime argument in this case should not be used

  • format = 1 - converts DateTime format to TimeNum format, example:

    mytimenum = DateTimeConvert( 1, DateTime() ); // - returns timenum
    date argument should be in datetime formattime argument in this case should not be used

  • format = 2 - converts from DateNum and optionally TimeNum to DateTime format, example:

    mydatetime = DateTimeConvert( 2, DateNum(), TimeNum() );
    date argument should be in datenum formattime argument (optional) should be in timenum format. In case of EOD data you can skip time argument:

    mydatetime = DateTimeConvert( 2, DateNum() );

  • format = 3 - (AB5.0 or higher) converts DateTime format to Seconds (00..59) example:

    myseconds = DateTimeConvert( 3, DateTime() );

    date argument should be in datetime, formattime argument in this case should not be used

  • format = 4 - (AB5.0 or higher) converts DateTime format to Minutes(00..59) example:

    myminute = DateTimeConvert( 4, DateTime() );

    date argument should be in datetime, formattime argument in this case should not be used

  • format = 5 - (AB5.0 or higher) converts DateTime format to Hours (00..23) example:

    myhour = DateTimeConvert( 5, DateTime() );

    date argument should be in datetime, formattime argument in this case should not be used

EXAMPLE
mydatenum =
DateTimeConvert( 0, DateTime() );// - this returns DateNum
mytimenum =
DateTimeConvert( 1, DateTime() ); // - returns timenum
mydatetime =
DateTimeConvert( 2, DateNum(), TimeNum() );
mydatetime =
DateTimeConvert( 2, DateNum() );
SEE ALSO DateNum() function , DateTime() function , DateTimeToStr() function , Day() function , DayOfWeek() function , DayOfYear() function , TIMENUM() function , MONTH() function , YEAR() function , HOUR() function , MINUTE() function , SECOND() function

References:

The DateTimeConvert function is used in the following formulas in AFL on-line library:

More information:

Updated on-line reference