Return Month name Jan for 1

  • Thread starter Thread starter Kay Starnes
  • Start date Start date
K

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?
 
hi Kay,

Kay said:
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?
Click to expand...
Use

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



mfG
--> stefan <--
 
.... you probably meant

Format(expression "mmmm")


Vanderghast, Access MVP


Stefan Hoffmann said:
hi Kay,

Kay said:
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?
Click to expand...
Use

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



mfG
--> stefan <--
Click to expand...
 
hi Michel,

Michel said:
... you probably meant
Format(expression "mmmm")
Click to expand...
No, not really. But I haven't read the post carefully enough, I really
thought (s)he wanted the number :(



mfG
--> stefan <--
 
hi Michel,


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

mfG
--> stefan <--
Click to expand...

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
 
Hey guys! You are funny but fredg's response hit the spot! Thanks so much!

fredg said:
hi Michel,


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

mfG
--> stefan <--
Click to expand...

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
Click to expand...
 
Back
Top