Locale doesn't appear to work in this formula

[Rob_atYahoo]

I have a Google sheet with Locale set to English Australia and the Data table in Appsheet is set to the same. All native fields are displaying correctly.
I then created a Week Commencing virtual variable: ([Work Date]-WEEKDAY([Work Date]-1))
And a Week Ending virtual variable: ([Week Commencing]+6)
And a Week Number virtual variable: "Week: " & WEEKNUM([Work Date]-1) & " - " & [Week Commencing] & " to " & [Week Ending]
However the Week Number variable displays the Week Commencing and Week Ending dates in US MM/DD/YYYY format.
Is there an easy fix or do I need to use the Day() Month() and Year() functions to split my date and then concatenate in DD/MM/YYYY format

[Aleksi · Accepted solution]

Before doing that, try to add TEXT expression before the date field like…
“Week: " &WEEKNUM([Work Date]-1)&” - “&TEXT([Week Commencing])&” to "&TEXT([Week Ending])

[Rob_atYahoo]

Brilliant, worked perfectly. Thanks!!!

[Aleksi]

The TEXT expression will change your date as per your locale settings.