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!
Solved! Go to Solution.
With the virtual column, use DAY([Date])&"/"&MONTH([Date])&"/"&YEAR([Date])
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |