DATE_FORMAT()

Syntax

Formatted_Date_Time_String as C = DATE_FORMAT( Date_Value as D, Custom_Date_Format as C )

Argument

Description

Formatted_Date_Time_String

Any portion(s) of a date time value in the specified format.

Date_Value

A representation of a date that satisfies the ISDATE()function.

Custom_Date_Format

Refer to Date and Time Format Elements. To include separators in the formatted result, include separators in the format string. For example, "MON, d-yyyy". To use a format code a separator, precede the code with the escape character ("\").

Description

DATE_FORMAT() returns a formatted character string representation of the Date_Value.

Supported By

Alpha Five Version 5 and Above

Example

dim dateString as C

Date_String = date_format(DATE() , "MON, d-yyyy")

Date_String à "JAN, 6-2003"

See Also

Date and Time Functions, ISDATE(), Date and Time Format Elements