Month error..

[CrystalSurfer]

Hi All,
I have the following calculated field in a query to grab the Month name:

MnthName: Format((Month([DateComplete])),"mmm")
where [DateComplete] is a Date/Time field from a table

Is this dubious at all?
Because the results come back with either "Jan" or "Dec" (NO other month names)
(Ive also tried the DatePart("m",[DateComplete]) function)

Strangely, comparing the error against the Month number (Mnth: Month([DateComplete])) it seems that 1 is always "Dec" and all the other month numbers are "Jan".

Example query results:
Mnth MnthName
3 Jan
11 Jan
10 Jan
9 Jan
9 Jan
11 Jan
12 Jan
1 Dec
1 Dec
2 Jan
11 Jan
7 Jan
7 Jan
6 Jan
2 Jan
1 Dec

Can someone please enlighten me?
Thanks...

 

[ColinEssex]

Try this

Format([DateComplete],"mmm")

Col

 

[CrystalSurfer]

Ah!
Nice one Col - Thank you.
It seems I was overly complicating it!

 

[ColinEssex]

No sweat, we've all done it

Col