Extract Month from DateTime and convert to text

[Sarah_Keown]

Hi, looking to sort attachments uploaded into the Year/Month they were uploaded. 

I have a Change Timestamp field capturing the date and time the file is uploaded. However I cannot get the Month converted to Text i.e. 2023 > February. Instead it comes through as 2023 >2 

I have tried the below; 

TEXT(MONTH([Date/Time Quotation Uploaded]))

[Suvrutt_Gurjar · Accepted solution]

Please try

TEXT([Date/Time Quotation Uploaded], "YYYY >MMMM")

If you wish to extract only month and not the year part, please try 

TEXT([Date/Time Quotation Uploaded], "MMMM")