I have a normal date column field. I need a calculated column displaying the month of this date.

How can I extract the month? I've already tried using this formula:


This formula


does the job

Or if you want the month name


To add I see in your formula there is a typo


instead of =TEXT([DATEFIELD],'MMM')


Your Answer

