Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

converting multi-format date field

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.

3 Replies
ariel_klien
Valued Contributor

Re: converting multi-format date field

Hi

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

BR

Ariel

MVP
MVP

Re: converting multi-format date field

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?

Not applicable

Re: converting multi-format date field

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.

Community Browser