Help Required in formula

[Mohini79]

Dear All,

I have column with date as ( 01-09-2022 ).

I want formula to extract only month and year in format mmm-yyyy.

Please help. 

Thanks in advance

[Yoshiro_Fujimori]

@Mohini79 ,

I would convert the date to Date type,

and then convert it to my favorite format.

Workflow

Formula

DateFormat = DateTimeParse([Date],"%d-%M-%Y")

mmm-yyyy = DateTimeFormat([DateFormat],"%b-%Y")

Output

Please see the attached workflow for detail.

[binu_acs]

@Mohini79 different approaches to achieve your result

DatetimeFormat(DateTimeParse([Date],’%d-%m-%Y),’%B-%Y’)

[Yoshiro_Fujimori · Accepted solution]

Sorry I found a mistake in my formula.

Wrong:   DateTimeParse([Date],"%d-%M-%Y")

Correct: DateTimeParse([Date],"%d-%m-%Y")

Correct output:

The formula is case-sensitive!!