topic Converting formats in QlikView

Converting formats

Anonymous — Sat, 20 Sep 2014 12:10:50 GMT

Hi all,

I am a qlikview learner , i have a requirement in which my data consists of different date formats eg('DD-MM-YYYY/DD-MMM-YYYY etc )

Now i am trying to convert all the above date formats in to one format Like 'MM-DD-YYYY') .Any Ideas please

Thanks In advance

Re: Converting formats

antoniotiman — Sat, 20 Sep 2014 12:18:15 GMT

Hi,

use Date# function.

E.g.

if your format is DD-MM-YYY

Date(Date#(fielddate,'DD-MM-YYY'),'MM-DD-YYY')

Regards

Re: Converting formats

MK_QSL — Sat, 20 Sep 2014 12:24:01 GMT

If you have more than one DateField, you need to use Alt, Date# and Date functions to convert to single format... Check below example where DateField is Converted to your requested Format..

I have kept DateField and NewDateField both for your comparison purpose.. You can obviously remove DateField and Rename the Formula as DateField...

Load

DateField,

Date(ALT(Date#(DateField,'DD-MM-YYYY'),Date#(DateField,'DD-MMM-YYYY')),'MM-DD-YYYY') as NewDateField

Inline

[

DateField

01-01-2014

20-09-2014

10-MAR-2014

15-SEP-2014

];

Re: Converting formats

Anonymous — Sat, 20 Sep 2014 13:19:11 GMT

Thanks Manish Kachhia !!!

Its Working for me