Help

Word Month Return

1126 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jssbghn
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

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

DATETIME_FORMAT({Date},'MMMM')

Screenshot 2020-04-24 at 09.38.44

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
4 - Data Explorer
4 - Data Explorer

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