Date Formats
Date Built-In Functions may use one or more of the following formats as arguments and/or return values. The relevant Built-In Function’s description tells you which format is used as arguments and/or return values.
|
Code |
Format of Date |
|---|---|
|
A |
System date format |
|
B |
DDMMYY |
|
C |
DD/MM/YY |
|
D |
YYMMDD |
|
E |
YY/MM/DD |
|
F |
MMDDYY |
|
G |
MM/DD/YY |
|
H |
DDMMYYYY |
|
I |
DD/MM/YYYY |
|
J |
YYYYMMDD |
|
K |
YYYY/MM/DD |
|
L |
MMDDYYYY |
|
M |
MM/DD/YYYY |
|
N |
DDMMMYY (e.g. 03JUL87) |
|
O |
DDMMMYYYY (e.g. 03JUL1987) |
|
P |
DDxx MMMMMMMMM YY (e.g. 16TH SEPTEMBER 87) |
|
Q |
DDxx MMMMMMMMM YYYY (e.g. 16TH SEPTEMBER 1987) |
|
R |
DDD (e.g. MON, TUE, WED, etc). |
|
S |
DDDDDDDDD (e.g. MONDAY, TUESDAY, WEDNESDAY, etc). |
|
T |
DDDDDDDDDD (in selected language e.g. LLLLLLLLLL). |
|
U |
MMMMMMMMMM (in selected language e.g. LLLLLLLLLL). |
|
V |
8 digit system date format |
|
W |
YYMM |
|
X |
MMYY |
|
Y |
YYYYMM |
|
Z |
MMYYYY |
|
1 |
CYYMMDD |