UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> convert digit date to character date    
 
   
access2009eg
post Apr 4 2008, 03:30 AM
Post #1

UtterAccess Guru
Posts: 860
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
Go to the top of the page
 
+
JayNoelOlimpo
post Apr 4 2008, 03:33 AM
Post #2

UtterAccess VIP
Posts: 7,990
From: Philippines
Hi;

Would date be presented as ...

dd/mm/yyyy ?

if so then ..

=Format(myDate,"mmmm")
MAY

HTH.
Go to the top of the page
 
+
access2009eg
post Apr 4 2008, 03:52 AM
Post #3

UtterAccess Guru
Posts: 860
thank you for your help

but you mean by "HTH"
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif) (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Go to the top of the page
 
+
JayNoelOlimpo
post Apr 4 2008, 03:53 AM
Post #4

UtterAccess VIP
Posts: 7,990
From: Philippines
HTH - Hope This Helps ...

Glad to be of Help. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/grin.gif)
GOOD LUCK!
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 04:07 PM