Email Report - Date format in subject of email

[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

 

[Stuart McCall]

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

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