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
|
|
|
|