Date format

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!

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

2 Likes

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.

You’re welcome

I have edited my previous reply :frowning:

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

1 Like