Printing the date in MMM CCYY format

[mohebk]

Hi,
I am writing a query and trying to convert the date to print the 3 letters month and the 4 digit year. This is the column code

Entered Month: Format(Month([Suggestions].[date_entered]),"MMM") & " " & Year([Suggestions].[Date_Entered])

It does print but a different month altogether not sure why or how to fix it.

For example:

Date Value Output
1/1/2009 Dec 2009
1/8/2009 Dec 2009

Please advise.
Thanks

Mo

 

[PHV]

Entered Month: Format([Suggestions].[date_entered]),"MMM YYYY")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mohebk]

There was an extra perent in there but i removed it and it worked fine.

Thanks as always

Mo