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
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;
Could 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.