topic converting multi-format date field in QlikView

converting multi-format date field

Thu, 06 Jun 2013 10:12:25 GMT

Hi,

I have a column storing date, with different format, it could be either DD/MM/YY or MM/DD/YY, is there a way to transform them to be all into same format?

Thanks.

Re: converting multi-format date field

ariel_klien — Thu, 06 Jun 2013 10:14:34 GMT

You can use Date(DateField,'DD/MM/YYYY')

Ariel

Re: converting multi-format date field

swuehl — Thu, 06 Jun 2013 10:22:15 GMT

Please have a look at the alt() function in the Help file.

But how do you know, if 01/02/2013 is Feb 1st or Jan 2nd?

Re: converting multi-format date field

Thu, 06 Jun 2013 11:32:02 GMT

Hi All,

That's the tricky part, all dates are in the same columns.

Just want to check if there's a quick way before correcting the data itself.

Thanks.