Today's date in UK format

[Tezz233]

I know to grab today's date, you use: 

Text( Today(), "mm/dd/yyyy")

or

Text( Today(), "[$-en-US]dd/mm/yyyy")

But these both grab the date in US format. How can I grab today's date in UK format? I tried Text( Today(), "dd/mm/yyyy"), but for some reason the result of today's date becomes: 8/10/2018. What should I do instead and is there any reason why the code I tried generates 8/10/2018?

[v-yamao-msft · Accepted solution]

Hi Tezz233,

When testing the function on my side, it returns the correct date and format.

The function I am using is:

I also try with this function, it works fine.

Please check the doc about Text function and try again with it.

Please also check the time zone on your side.

Please feel free reply if you are still having the issue.

Best regards,
Mabel Mao