Access Query: Return Month Name and Year

[PhatRam32]

So one of my co-workers still is on access 2003 (long story) and trying to return month name and year. I gave her my function I use in 2010 version however it does not work on hers. Anything else she can try?



Here is what I gave her..works on my end but not her 2003 version of access : format([date_field], "mmmm yyyy")

Supposed to read as follows: (example) May 2013 for any date that falls in May.

Thanks in advance for the help.

[rzw0wr]

try this
MonthName(Year(SomeDate))

for this month use MonthName(Year(Date()))

Dale

[PhatRam32]

SomeDate I am assuming is my date field.. i.e. MonthName(Year([DOB])) So if the date is 02/05/1982 it should return as: February 1982, correct?

[rzw0wr]

YES, I hope I got the syntax correct.
MonthName = name of the month
Year= year of date

Dale

[PhatRam32]

Will have her try it on her and will follow up. I tried it in 2010 just for the heck of it but it did not work and my guess is because its not supported in the newer versions of access.

[rzw0wr]

I had the wrong syntax.
try
MyDOB: MonthName(Month([DOB])) & " " & Year([DOB])

Dale

[PhatRam32]

I had the wrong syntax.
try
MyDOB: MonthName(Month([DOB])) & " " & Year([DOB])

Dale

It works in 2010 I am keeping my fingers crossed it will work in 2003 version, I do not see why not based on some quick research I did just now. Many thanks and will keep you posted.

[rzw0wr]

Glad to help. Should work in 2003.

Dale