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?
Month in words. Jan for January. Can you help?
S
Stefan Hoffmann
hi Kay,
Month: Format([yourField], "m")
mfG
--> stefan <--
UseKay said:
Month: Format([yourField], "m")
mfG
--> stefan <--
M
Michel Walsh
.... you probably meant
Format(expression "mmmm")
Vanderghast, Access MVP
Format(expression "mmmm")
Vanderghast, Access MVP
Stefan Hoffmann said:
S
Stefan Hoffmann
hi Michel,
thought (s)he wanted the number
mfG
--> stefan <--
No, not really. But I haven't read the post carefully enough, I reallyMichel said:
thought (s)he wanted the number
mfG
--> stefan <--
F
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
K
Kay Starnes
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 <--
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