DateFmt

Returns a date format string, given a date format style.

Syntax

DateFmt([n [, k ]])

Parameters

Parameter

Description

n (optional)

An integer identifying the locale-specific time format style as follows:

  • 1 (Short style)

  • 2 (Medium style)

  • 3 (Long style)

  • 4 (Full style)

If n is omitted (or is invalid), the default style value 0 is used.

k (optional)

A locale identifier string that conforms to the locale naming standards. If k is omitted (or is invalid), the ambient locale is used.

Examples

The following expressions are examples of using the DateFmt function:

Expression

Returns

DateFmt(1)

M/D/YY (if en_US locale is set)

DateFmt(2, "fr_CA")

YY-MM-DD

DateFmt(3, "de_DE")

D. MMMM YYYY

DateFmt(4, "fr_FR")

EEEE D' MMMM YYYY

// Ethnio survey code removed