Date serial to texte

1

Hi, I have a text field with a date serial number, for instance : 41901

Format(asnumber([Date (d/m/y)]),"yyyy/mm/dd")

returns 2014-00-19 in Easymorph, Excel returns 2014-09-19 !!!
All the months are "00".

I'm I doing something wrong in the conversion.

In control panel It's yyyy-mm-dd

2

Hello @Yves_Allaire ,

the correct formula is Format(asnumber([Date (d/m/y)]),"yyyy/MM/dd")

(MM in the format value)

I hope this could help!

3

Great, that worked,

I must have overlooked the Uppercase of the m's

Thanks.

4

You can find the full details of supported format strings here Date(datetime, format) [EasyMorph Help]

"mm" is the minutes from a timestamp where as "MM" is the 2 digit month number.

5

Alternatively, use the new expression generation from a description feature (v5.9.6 or above). See example