Page History
...
SYSFMT | (QDATFMT) |
SYSFMT8 | (8 digit date in QDATFMT format) |
DDMMYY | (Day, Month and Year) |
MMDDYY | (Month, Day and Year) |
YYMMDD | (Year, Month and Day) |
DDMMYYYY | (Day, Month and Full Year) |
MMDDYYYY | (Month, Day and Full Year) |
YYYYMMDD | (Full Year, Month and Day) |
YYMM | (Year and Month) |
MMYY | (Month and Year) |
YYYYMM | (Full Year and Month) |
MMYYYY | (Month and Full Year) |
CYYMMDD | (Century indicator, Year, Month and Day) |
Notes
- The CYYMMDD format is only valid as a format for a real field on LANSA virtual field derivation. It can be defined in Visual LANSA, but not made operational.
- If an alpha date field (real or virtual) is being converted to a resulting numeric date field (real or virtual), a check will be automatically performed to ensure the resulting numeric date field contains all numeric characters ("0" to "9"), if the resulting numeric date field does not contain all numeric characters (i.e. alpha characters have been found) the resulting numeric date field will be set to 0.
- If a date containing just Month and Year is to be converted to a date containing Day, Month, and Year, a day of 01 will be used for the resulting date. eg MMYY of 1296 to be converted to DDMMYYYY will result in 01121996.
- If a date containing zeros is to be converted to, for example, YYYYMMDD format, the resulting date will be 19000000.