How to read in ambiguous date styles?

Nico Chart_21517
Nico Chart_21517
Altair Employee
edited June 2023 in Altair RapidMiner

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.

 

Tagged: