UtterAccess Discussion Forums > convert digit date to character date

Full Version: convert digit date to character date

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

access2009eg

Apr 4 2008, 03:30 AM

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

Apr 4 2008, 03:33 AM

Hi;

Would date be presented as ...

dd/mm/yyyy ?

if so then ..

=Format(myDate,"mmmm")
MAY

HTH.

access2009eg

Apr 4 2008, 03:52 AM

thank you for your help

but you mean by "HTH"

JayNoelOlimpo

Apr 4 2008, 03:53 AM

HTH - Hope This Helps ...

Glad to be of Help.

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.