Sharepoint column format issue

Question

Hi all - trying to figure out why "year 1 review" column won't format to match Year 2 and Year 3. I don't want year 1 to say Friday, I want it to say October 24, 2025. I've deleted the column, checked formatting and nothing will change it.

Help, please.

Answer 1

Dear @Scott Friend, 

Thank you for posting your question in the Microsoft Q&A forum.  

I understand how inconvenient it must be to encounter formatting inconsistencies.  

This usually happens because: 

• The column type or display format is set incorrectly (e.g., “Friendly format” enabled). 
• JSON formatting is inconsistent across columns. 
• The column might be using a calculated field or custom JSON that returns only the day name. 

To help me better understand the situation and assist you effectively, could you please share the detailed JSON applied to each column? 

This will help us better understand the context and provide more targeted support. Any additional information will help us better understand and support you.    

In the meantime, you refer to some workarounds to verify the issue:   

Option 1: Check column settings 

Go to your SharePoint list. 

Click Settings > Select List settings. 

Under Columns, select Year 1 Review. 

Ensure:  

• Column type = Date and Time. 
• Format = Date Only (uncheck “Friendly format” if enabled). 
• Save changes. 

 

Note:  

If the column is a calculated field, you cannot directly change its display format. You’ll need to adjust the formula or use JSON formatting. 

Option 2: Consider implementing this JSON format

You can review this JSON I’ve prepared. It’s designed to display the date in Month Day, Year format similar to yours: 

{ 
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", 
"elmType": "span", 
"txtContent": "=if(getMonth(@currentField)==0,'January ',if(getMonth(@currentField)==1,'February ',if(getMonth(@currentField)==2,'March ',if(getMonth(@currentField)==3,'April ',if(getMonth(@currentField)==4,'May ',if(getMonth(@currentField)==5,'June ',if(getMonth(@currentField)==6,'July ',if(getMonth(@currentField)==7,'August ',if(getMonth(@currentField)==8,'September ',if(getMonth(@currentField)==9,'October ',if(getMonth(@currentField)==10,'November ',if(getMonth(@currentField)==11,'December ','No date')))))))))))) + getDate(@currentField) + ', ' + getYear(@currentField)" 
} 

Here’s the result from the test I ran in my environment: 

 

As community moderators, we kindly ask for your understanding that our access to internal development details is limited. Our primary role is to guide users toward the appropriate resources and support channels. While we may not have visibility into performing deeper backend analysis, we’ll continue doing our best to support you within the scope of our responsibilities.  

I hope the information provided proves useful. Please proceed with the outlined steps and let me know whether they resolve the issue. If not, I’ll be glad to continue working with you to find a solution. 

Thank you for your patience and understanding throughout this process. Should you have any questions or need further assistance, feel free to reach out at any time. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.