Returns a date format string, given a date
format style.
SyntaxDateFmt([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.
|
ExamplesThe
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
|
|
|
|