Solved: Date() function change the date format - Page 2

paullynun · 04-10-2020 05:05 PM

What make the Date() function to change the date format?

I use the following formula Concatenate([Abréviation]," “,Date([Date]),” ",[Nom]). It appears that the date format is change by this function.

Kirk_Masden

In this case, I think you will need to use TEXT() to designate the format you would like:

Here’s an example in that article:

TEXT(“2019-11-01”, “dd/mm/yyyy”)

So, if you want 2020-04-09

Concatenate([Abréviation]," “, TEXT([Date],“yyyy-mm-dd”) ,” ",[Nom])

should work.