Date() function change the date format

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.

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.

4 Likes

This will work in my scenario. Thanks @Kirk_Masden!

3 Likes