How to change the date format in a Lists column?

Question

I have a column in Lists that shows due dates, but by default the dates display in the month/day/year format. How can I change this to be in day/month/year format? I have seen the "friendly format" button but this doesn't exactly do what I need.

Answer 1

Hi,

Thank you for posting your query in our community.

Based on your description, you want to change date format from month/day/year format to day/month/year format, you can follow the below steps:

1. Go to your list, where you would like to see the formatted date and time.
2. We need to add a calculated column to display the format and use the sample code given below(you could hide the original column if you don't want):

Below is the test result:

Best regards,

Jazlyn

Answer 2

Hi Jazlyn, thank for that. I have tried to follow your steps but unfortunately when clicking save I get an error saying that the formula is referring to a column that doesn't exist, which is odd. I can't see where I have made the mistake?

Answer 3

Hi,

Since your original date column named "Due Date", you need to change the "Date" value in the formula to "Due Date"(you can first type =TEXT(, then double-click the Due Date column in the right pane), so the formula will show like this: =TEXT([Due Date],"DD/MM/YYYY")

Best regards,

Jazlyn

Answer 4

Ah perfect, thank you. I had thought that "Date" was the type of column as oppose to the name.