Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting Dates

Status
Not open for further replies.

smdemo

Programmer
Sep 15, 2002
63
US
I have a report where I prompt for a user to enter a date that will be used on a letter that is generated and I need to learn how to convert the date they enter when prompted when opening the report to mmmm dd, yyyy. My big issue is that this is part of a concatenated text box below. Does anyone know hoe to do this?

"The NCDoI has sent notification that as of " & I Need to convert the date here. & " you have not met your Continuing Education requirements."

I have converted the date in its own text box and have tried referring to that text box that is converted and it does not work.
 
I'm sorry everyone, I got it. I feel dumb now...

Format(Date user enters,"mmmm dd"", ""yyyy")
 



ONE set of quotes....
Code:
Format([Date user enters],"mmmm dd, yyyy")

Skip,
[sub]
[glasses] When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top