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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Date Formatint    
 
   
MJCIII
post Jun 14 2006, 07:44 PM
Post #1

UtterAccess Addict
Posts: 192
From: California
I have the following statement in a text box and would like to format the dates to print out the full month and the day. (example January 1 through March 31)

="Plan Year:" & Month([PlanBeg]) & " " & Day([PlanBeg]) & " through " & Month([PlanEnd]) & " " & Day([PlanEnd])

I'm not sure where to put the format statement. How can I do this?

Thanks

Mike
Go to the top of the page
 
+
R. Hicks
post Jun 14 2006, 07:49 PM
Post #2

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
Try ....

CODE
= "Plan Year:" & Format([PlanBeg], "mmmm d") & " through " & Format([PlanEnd], "mmmm d")


RDH
Go to the top of the page
 
+
« Next Oldest · Access Reports · 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: 24th May 2013 - 09:52 AM