Sharepoint list - new column date format from a calculated field

Question

Hi All,

Wondering if anyone can help please?

I currently have a calulcated date column in the format 01/01/2023, i have had a lot of issues changing the format to 01/JAN/2023.

I was hoping to create another new column in the list, converting the current date field with the 01/01/2023 to the date format 01/JAN/2023.

Is this possible?

Thanks in advance.

Answer 1

Dear Carmel Arcangel.

Good day! Thank you for posting to Microsoft Community. We are happy to help you

 Please try the following:

 

We look forward to your reply. Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator

Answer 2

This didn't work, thanks for your help

Answer 3

Dear Carmel Arcangel.

I did a detailed test for you, you can refer to the following steps to see if I can help you.

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.

Sincerely,

Tin | Microsoft Community Moderator

Answer 4

Thank you. I think the problem is that the column i wish to copy and create the ddMMMyy i also a calculated field. Maybe that's why it's not working?

Answer 5

Dear Carmel Arcangel M,

Good day!

Calculated columns need to depend on other columns, you can refer to the formula in my above test that references the "Date" column, you can not copy and paste calculated columns alone.

Thanks for your cooperation.

Sincerely,

Tin | Microsoft Community Moderator