Date String to Month Number??

[Bill]

Hi All,

I'm sure I am missing something obvious here!!

I have a field populated with three character month names, Jan, Feb, Mar
etc. I would like a calculated field in a query to display the Month Number
with Jan as 1, Feb as 2 etc and can't spot it!!

Can anyone help please?

Ta.
Bill.

[Jeff Boyce]

Bill

Take a look at the Format() function. You can use it to display (*rather
than calculate*) a date as MMM -- no need to store that separately if you
already have a date/time field. Use a query to help with the formatting.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Post by Bill
Hi All,
I'm sure I am missing something obvious here!!
I have a field populated with three character month names, Jan, Feb, Mar
etc. I would like a calculated field in a query to display the Month
Number with Jan as 1, Feb as 2 etc and can't spot it!!
Can anyone help please?
Ta.
Bill.

[Douglas J. Steele]

And if you don't already have a date/time field, you can use:

Month(CDate("01 " & [MonthNameField] & " 2007"))

where MonthNameField is the name of the field containing your 3 character
month.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Post by Jeff Boyce
Bill
Take a look at the Format() function. You can use it to display (*rather
than calculate*) a date as MMM -- no need to store that separately if you
already have a date/time field. Use a query to help with the formatting.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Bill
Hi All,
I'm sure I am missing something obvious here!!
I have a field populated with three character month names, Jan, Feb, Mar
etc. I would like a calculated field in a query to display the Month
Number with Jan as 1, Feb as 2 etc and can't spot it!!
Can anyone help please?
Ta.
Bill.