Blog Archive

LANSA Date Formats Cheat Sheet

These are useful when doing LANSA date conversions using the DATE Built-in functions !

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