Date format

[AlexM]

Hello guys,

I have a virtual column with:
CONCATENATE([DATE]," - ",[Name])

The date in the date column is dd/mm/yyyy.
In the CONCATENATE column is mm/dd/yyyy.

Why and any idea on how to fix it?
I want dd/mm/yyyy.

(in Google Spreadsheet is also stored as dd/mm/yyy)

Thank you!

[Aleksi]

Write it as TEXT([DATE])&" - "&[Name]. TEXT expression convert your date value as your locale settings.

[AlexM]

Thanks!

Edit:

It doesn’t work.
The purpose of the column is to be the Label.

Changed the label from the virtual column to the local column [Date] and the format is the right one.
Back to the virtual column (TEXT…) still wrong.

[Aleksi]

You’re welcome

[AlexM]

I have edited my previous reply

[Aleksi · Accepted solution]

With the virtual column, use DAY([Date])&"/"&MONTH([Date])&"/"&YEAR([Date])