Solved: Date() function change the date format

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.

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.

paullynun

This will work in my scenario. Thanks @Kirk_Masden!

Sara_Bertomeu

I use, in Google calendars:

CONCATENATE(DAY([Start]),"/",MONTH([Start]),"/",YEAR([Start])," ",TIME([Start]))

result

Thanks Sara