Return Month name Jan for 1

[Kay Starnes]

I have a date/time field and need to return "m" not the number 1 but the
Month in words. Jan for January. Can you help?

 

[Stefan Hoffmann]

hi Kay,

I have a date/time field and need to return "m" not the number 1 but the
Month in words. Jan for January. Can you help?

Use

Month: Format([yourField], "m")



mfG
--> stefan <--

 

[Michel Walsh]

.... you probably meant

Format(expression "mmmm")


Vanderghast, Access MVP

hi Kay,

I have a date/time field and need to return "m" not the number 1 but the
Month in words. Jan for January. Can you help?

Use

Month: Format([yourField], "m")



mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Michel,

... you probably meant
Format(expression "mmmm")

No, not really. But I haven't read the post carefully enough, I really
thought (s)he wanted the number



mfG
--> stefan <--

 

[fredg]

hi Michel,


No, not really. But I haven't read the post carefully enough, I really
thought (s)he wanted the number

mfG
--> stefan <--

Actually guys, if I understand the original poster correctly
("...Month in words. Jan for January" , she wants a 3 letter month
name "Jan", so:
=Format([DateField],"mmm")
or simply set the Format property of the Date control to:
mmm

 

[Kay Starnes]

Hey guys! You are funny but fredg's response hit the spot! Thanks so much!

hi Michel,


No, not really. But I haven't read the post carefully enough, I really
thought (s)he wanted the number

mfG
--> stefan <--

Actually guys, if I understand the original poster correctly
("...Month in words. Jan for January" , she wants a 3 letter month
name "Jan", so:
=Format([DateField],"mmm")
or simply set the Format property of the Date control to:
mmm