In my google sheet locale format is English. I enter all dates in format dd.mm.yy - its ok.
But when I write query with "select" dates and Concatenate with other data like (in output): "ClientName - DateOfBirdth", so i receive:
"John Smith - mm/dd/yy".
But I need:
"John Smith - dd.mm.yy"
Where can I it change? Or It is Concatenation rules?
LinkedIn
Twitter
