LANSA Date Formats Cheat Sheet

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

CodeFormat of Date
ASystem appointment format
BDDMMYY
CDD/MM/YY
DYYMMDD
EYY/MM/DD
FMMDDYY
GMM/DD/YY
HDDMMYYYY
IDD/MM/YYYY
JYYYYMMDD
KYYYY/MM/DD
LMMDDYYYY
MMM/DD/YYYY
NDDMMMYY (e.g. 03JUL87)
ODDMMMYYYY (e.g. 03JUL1987)
PDDxx MMMMMMMMM YY (e.g. 16TH SEPTEMBER 87)
QDDxx MMMMMMMMM YYYY (e.g. 16TH SEPTEMBER 1987)
RDDD (e.g. MON, TUE, WED, etc).
SDDDDDDDDD (e.g. MONDAY, TUESDAY, WEDNESDAY, etc).
TDDDDDDDDDD (in selected linguistic communication e.g. LLLLLLLLLL).
UMMMMMMMMMM (in selected linguistic communication e.g. LLLLLLLLLL).
V8 digit organization appointment format
WYYMM
XMMYY
YYYYYMM
ZMMYYYY


Sumber http://www.mysamplecode.com/