Creating new column as Month (MMM) from date

[Adam_B]

Hello, 

I have a date set, 01/01/2023 that I want to add a new column to output the Month name, so in the example I would like JAN as the output.  

I tried this formula, 

DateTimeFormat([APH REQ Action Date],"%B")

However, the output is all NULLs. 

Any help would be appreciated. 

Thanks, 

Adam 

[ShankerV · Accepted solution]

Hi @Adam_B 

One way of doing this.

DateTimeFormat(DateTimeParse([Field1],"%m/%d/%y"),"%b")

Note: The formula you have used was right but however the datetime formula will produce successful results if the date is in ISO format YYYY-MM-DD

Hence used datetime parse to convert to ISO format and then applied your formula.

Many thanks

Shanker V

[Adam_B]

@ShankerV That worked, thank you!