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
Solved! Go to Solution.
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.
@Mohini79 different approaches to achieve your result
DatetimeFormat(DateTimeParse([Date],’%d-%m-%Y),’%B-%Y’)
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!!