Skip to main content

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.

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

take.ms/zd1M4 - screenshot link here

yup, it was date field.

Reply


Terms & Conditions