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!