How to get the Month Number from a Date field

[#1]

Hi There

I have a date field in the format DDMMMYYYY and in addition to the standard date information that I am extract from that field (i.e. month name, week commencing etc) I want create a field with the month number.

So the date of '01APR2015' should give me 4.

Any help appreciated.

JW

[Anonymous]

=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')

[maxgro]

=num(month(date#( '01APR2015' ,'DDMMMYYYY')))

[#4]

Fantastic, thank you!

[#5]

Brilliant, Thank you

[rwunderlich]

Bill,

Your solution does not return the month number. It runs the same date with a display format of "M".

=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')

=date(date#( '14APR2015' ,'DDMMMYYYY'),'M')

would create two rows in a listbox or chart which is probably not what the poster wants.

-Rob