Converting date (number) to text

[#1]

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]

Try giving it a date display format in the script:

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

[#3]

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

[anandathome · Accepted solution]

you can try

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

OR

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.

[#5]

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