Full Version: convert digit date to character date
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
access2009eg
If i have date like this
1/5/2008

I want to take the Month (5) (only) not all date in query and display it as MAY not 5

Example
digit date charcter date
1/5/2008 MAY
JayNoelOlimpo
Hi;

Would date be presented as ...

dd/mm/yyyy ?

if so then ..

=Format(myDate,"mmmm")
MAY

HTH.
access2009eg
thank you for your help

but you mean by "HTH"
sad.gif sad.gif
JayNoelOlimpo
HTH - Hope This Helps ...

Glad to be of Help. grin.gif
GOOD LUCK!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.