UtterAccess Discussion Forums

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

MJCIII

Jun 14 2006, 07:44 PM

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

R. Hicks

Jun 14 2006, 07:49 PM

Try ....

CODE

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

RDH

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.