Format Date Locale from NOW()

[Sarah_Keown]

Hi, I’m keeping a log of comments made in my form and when I comment is made the date/time is logged on it but I can’t format the date to the correct locale (english UK). See below output and formula.

Formula:

Output:

Anyone can help?

[LeventK · Accepted solution]

@Sarah_Keown
Re-format NOW() with TEXT()
TEXT(NOW(), "DD/MM/YYYY HH:MM:SS")

[Sarah_Keown]

This is brilliant, thank you so much

[nhcohen]

Unfortunately, this solution does not allow for customization of date input fields.