Share via

Sharepoint list - new column date format from a calculated field

Anonymous
2023-06-16T00:18:44+00:00

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.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-27T00:15:54+00:00

    Thank you for your reply. Much appreciated.

    In my case, does it matter that the "DATE" column is also a calculated column?

    Thanks,

    Carmel

    0 comments
  2. Anonymous
    2023-06-28T00:25:16+00:00

    Dear Carmel Arcangel ,

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

    In my test,  DATE" column can be a calculated column.

    Sincerely,

    Tin | Microsoft Community Moderator

    0 comments
  3. Anonymous
    2023-06-28T00:56:56+00:00

    OMG i did it. Thank you Thank you. Now for the next bit, what if i want to colour code that new column to show todays date in Yellow, After todays date in Green and before today date in Red. Is that possible?

    0 comments
  4. Anonymous
    2023-07-03T09:51:42+00:00

    Dear Carmel Arcangel,

    Good day!

    Your requirements should belong to the conditional filter column data, which can theoretically be done with Jason code.

    However, please understand that this query is outside of our support boundaries. For you to be assisted properly, please reach out to Microsoft supported products on Q&A | Microsoft Learn; I am sure that our experts from that team can address your query effectively and accurately.  

    Thank you for your cooperation and understanding. Please do not hesitate to post your queries in Microsoft Community and we will always do our best to assist you!

    Sincerely,

    Tin | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments