How to read in ambiguous date styles?
Nico Chart_21517
Altair Employee
The ANYDT… informats are influenced by the DATESTYLE system option which in turn is influenced by the LOCALE setting. If your LOCALE setting is ENGLISH_UNITEDSTATES then the DATESTYLE system options is set to MDY. If ambiguous dates are found such as 12/03 then 03DEC will be returned when you may be expecting 12MAR.
The solution is either to change your LOCALE to EN_GB so that the DATESTYLE is changed to DMY and you will then see 12MAR generated or to simply define the DATESTYLE system option to be DMY.
0