topic Re: Date format Conversion in QlikView

Date format Conversion

Wed, 19 Dec 2012 09:27:51 GMT

Hi there,

I have a date with this format: Apr 13 2012 1:07PM and i want to convert it into 13/4/2012.

Any help?!

Thank you.

Anonymous — Wed, 19 Dec 2012 09:39:35 GMT

date(floor(timestamp#(DATEFIELD,'MMM DD YYYY h:mmTT')),'DD/M/YYYY') as NEWDATEFIELD

Wed, 19 Dec 2012 11:33:00 GMT

Thank you for your answer!

The problem remailns unfortunately in most of the records even though some have been transformed the way i wanted to.

For example: Feb 6 2012 9:26AM has been successfuly changed

But Feb 6 2012 11:38AM has not.

er_mohit — Wed, 19 Dec 2012 11:42:32 GMT

you change format hh:mmTT as expression in johannes sunden

hope this will helps you

Gysbert_Wassenaar — Wed, 19 Dec 2012 12:33:12 GMT

Try replacing the double spaces with single spaces:

date(floor(timestamp#(replace(DATEFIELD,' ',' '),'MMM DD YYYY h:mmTT')),'DD/M/YYYY') as NEWDATEFIELD

Wed, 19 Dec 2012 12:51:45 GMT

Thank you all! I fixed it!

Anonymous — Thu, 20 Dec 2012 02:18:14 GMT

Haha, and I paid such attention to get the double spaces in there to match the date format you posted in the original post..

Glad you got it up and running mate!