Loading date fields from string values

Anonymous — Fri, 08 Apr 2016 15:44:06 GMT

I've got a question on formating while loading date fields from a source.

Mij date fields has the format "2016-04-07T17:41:01Z"

For this date to be imported as a date field I use 2 replace functions to get rid of the T and Z sign.

In the next step I use Date#( to convert it to a datefield and with Date( I format it.

This looks like this and works

Date(Date#(Replace(Replace(DATEFIELD, 'T',' '),'Z',''), 'YYYY-MM-DD hh:mm:ss'), 'DD-MM-YYYY') as DATEFIELD

My question; has anyone a sollution to make this statement simpler / more elegant.

Roland Raijmakers

Re: Loading date fields from string values

sunny_talwar — Fri, 08 Apr 2016 16:48:14 GMT

Have you tried this may be:

Date(Date#(Left(DATEFIELD, 10), 'YYYY-MM-DD'), 'DD-MM-YYYY') as DATEFIELD