Date. Format to another Format.

[#1]

Hi.

I know i have to use this function

Date(Date#(Fecha, 'The format of my function'),'YYYY-MM-DD') AS Fecha2,

But i dont know that format my date uses, is something like this

41764

41765

etc..

somebody knows what i have to put to change the format of my date?

thank you all!

[maxgro · Accepted solution]

date(41765, 'DD/MM/YYYY')