Date format in SharePoint list

Question

Hi ,

We are running on SharePoint Modern Team site and we wanted to change date format in SharePoint list. For date and time column,there are only two date format supported right now (Standard and Friendly). We want date to be displayed in "DD-MMM-YY" format (eg: 14 Jun 2020). 

How could we achieve this using SharePoint out of the box feature or Is there any workaround for this ?

Thanks

Answer 1

Hi Pawankumar,

To change date format on a list to DD-MMM-YY, you can follow the below steps:

1. Go to your list, where you would like to see the formatted date and time.
2. I have a list named list-madoc and a column called Date in my list. Currently, it displays SharePoint default date and time format.

3. Now, we would like to display date DD-MMM-YY, as shown in the picture given below. We have added a new column to display the format.

4. To achieve this, we need to add a calculated column and use the sample code given below.

Column Name	Calculated Column Formula Value
Date_Formated_dd mmm yy	=TEXT(Date,"dd mmm yy")

Note: This kind of date and time format can only be achieved via a calculated column. It cannot be achieved by directly formatting the Date and Time column for the time being.

Best regards,

Madoc

Answer 2

Hi Pawankumar,

Haven't heard from you for a while. Feel free to post back if you need further assistance.

Best regards,

Madoc