Return Months from Start/End Dates

[jssbghn]

I’m trying to get date column month only in another column. But it returns in number, not actual month word.
Tried DATETIME_FORMAT({Actual Publishing Date},‘MMMM’) but it didn’t work please help.

[JonathanBowen]

hmmm…your formula it totally fine. This works for me:

DATETIME_FORMAT({Date},'MMMM')

Two things - make sure your quotes around MMMM are plain text, not formatted text (although this would give an error not a number if this was the problem). Your “Actual Publishing Date” field is a date field, yes?

JB

[jssbghn]

take.ms/zd1M4 - screenshot link here
yup, it was date field.