Email Report - Date format in subject of email

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Hi,

How do i change the date format from 2010/01/25 to 25-Jan-2010 in the
subject of my email? The fields dateStartDate and dateEndDate are the fields
containing the info.

The code as follows:

DoCmd.SendObject acReport, stDocName, acFormatPDF, "txtToEmail",
"txtCCEmail", "", "Attendance Register: " & txtCourse & " on " &
dateStartDate & " to " & dateEndDate & " - " & txtCompany & " - " & numRoom,
"Hi... Blah Blah Blah"

Thanks

ant1983
 
ant1983 said:
Hi,

How do i change the date format from 2010/01/25 to 25-Jan-2010 in the
subject of my email? The fields dateStartDate and dateEndDate are the
fields
containing the info.

The code as follows:

DoCmd.SendObject acReport, stDocName, acFormatPDF, "txtToEmail",
"txtCCEmail", "", "Attendance Register: " & txtCourse & " on " &
dateStartDate & " to " & dateEndDate & " - " & txtCompany & " - " &
numRoom,
"Hi... Blah Blah Blah"

Thanks

ant1983
Click to expand...

....
Format(dateStartDate, "dd-mmm-yyyy") & "to " &
Format(dateEndDate,"dd-mmm-yyyy")
....
 
Back
Top