Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')
=num(month(date#( '01APR2015' ,'DDMMMYYYY')))
Fantastic, thank you!
Brilliant, Thank you
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