Format to Long Date in Access 2010

[buckeyepilot67]

Alright, newbie here again needing assistance. I have searched and searched for the answer, but no luck. I am looking to format a short date (3/18/12) into a long date (Sunday, March 18, 2012) in Access. I have basically taken information that is downloaded into a table and created a form off of it. Then that form can automatically send an email. What I need is for the date to be long form in the email portion even though it is downloaded into the table in short form. The email works perfectly except for the formatting of the date needing changed. Anyone have any suggestions?



Dim email, fname, lname, team, SalesVP, deptairport, arrairport, dat, strBody, bccemail As String
Dim objOutlook As Object 'outlook.Application
Dim objEmail As Object ' outlook.MailItem

email = Me!ContactInfo
fname = Me!First
lname = Me!Last
dat = Me!FlightDate

So basically Me!FlightDate is in short date form.


Thanks again for your help.

 

[dhookom]

If the FlightDate field is truly a date data type then try:

dat = Format(Me!FlightDate,"dddd, mmmm dd, yyyy")

Duane
Hook'D on Access
MS Access MVP

 

[MazeWorX]

dat = Format(Me!FlightDate, "dddd mmmm dd, yyyy")

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[MazeWorX]

lol need to refresh the page next time

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[buckeyepilot67]

I knew it was something that easy, I kept trying to put in "Long Date". Thank you, Thank You for your help.