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.
Word Month Return
This topic has been closed for replies.
+18hmmm…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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.