ISO format Date


In an Opendata database, date are encoded in this iso format ( :
Complete date plus hours, minutes and seconds:
YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)

in my case :

A “Convert Data Type > Text to Date transformation” failed.
Any other options?

Best regards,

Hi Michel,

use format yyyy-MM-ddTHH:mm:sszzz in the “Convert Data Type” transformation.

Thank’s for your rapid answer, as usual.
Always less than 24 hours for an answer, hats off!

You’re welcome, Michel.

Hi Dmitry,
Perhaps you could add on day this format in the autodetect…

Already added. It will work in autodetect starting from v3.8. Not only this but all ISO date formats with timezones and fractions of seconds.

Great !!!
I like the continuous improvement of EasyMorph!