topic Re: Converting date (number) to text in QlikView

Converting date (number) to text

Fri, 05 Jul 2013 14:22:20 GMT

Hello,

I read a lot of posts about converting dates to various formats, but still can not get a correct presentation in my chart. Here is my problem:

I have a date field "Datum", I selected a single date (May 13, 2013).

When I put "=Datum" in a chart or textbox is represented as "41407".

To get this represented as "13-05-2013" I tried "=Date(Datum,'DD-MM-YYYY')", but this results in "-".

When I try "=Date(41407,'DD-MM-YYYY')" it is represented as "13-05-2013".

As information, in the script I use: Date#(Datum,'DD/MM/YYYY') AS Datum

Anyone any ideas? Many thanks

Btw I did also try various other combinations like

Date(Date#(Datum,'DD/MM/YYYY'),'DD/MM/YYYY')

Gysbert_Wassenaar — Fri, 05 Jul 2013 14:41:38 GMT

Try giving it a date display format in the script:

Date(Date#(Datum,'DD/MM/YYYY'),'DD-MM-YYYY') AS Datum

Fri, 05 Jul 2013 14:43:32 GMT

Thanks for the tip, I'll try it (reload will take some time)

anandathome — Fri, 05 Jul 2013 14:46:14 GMT

you can try

Date(Date#(Datum),'DD/MM/YYYY')

Date(num#(Datum),'DD/MM/YYYY')

How to format will definitely depend on how it is in source and

how you are interpreting it in script.

Fri, 05 Jul 2013 15:01:14 GMT

Thank you, Date(num#(Datum),'DD/MM/YYYY') did the trick!