Date format in Report

[SKETCHwade]

Hi,

I am from Australia and here we format our dates by DD/MM/YYYY
I have changed the locale setting in sheets to fix this, but when I make a report the date format is the default American type format. I’ve used a template and atttempted to change the language setting in hopes this will change it but it has’nt. I am unable to format the template text itself because it is Formulas made from text.

Any Ideas?

[Aleksi · Accepted solution]

Try to wrap your date value with the TEXT expression.