CDONTS with Date Format

[Brachole]

Hi, I'm using CDONTS in my ASP pages to send email notifications, using data from my Access DB.

My DB contains a date field which uses format mm/dd/yyyy (3/15/2006).

However, when displaying that record in CDONTS, the email is displaying 'Wed Mar 15 00:00:00 EST 2006'

I have enabled HTML so how can I display as mm/dd/yyyy in the email (or can I)?

Here's my code:

<%
var domain = "somedomain.com"
var username_from = "servicecenter"
var objCDOMail = Server.CreateObject("CDONTS.NewMail");
var objCDOMailFrom = username_from + "@" + domain;
var objCDOMailTo = (rsRMANumber.Fields.Item("EmailAddress").Value);
objCDOMailCc="";
objCDOMailBcc="";
var objCDOMailSubject = "Tracking Information for your order " + (rsRMANumber.Fields.Item("PurchaseOrder").Value);
objCDOMail.BodyFormat = 0
objCDOMail.MailFormat = 0
var objCDOMailImportance = 2;
var strBody = "<font size=2 face=Arial, Helvetica, sans-serif>Dear "+ (rsRMANumber.Fields.Item("ContactName").Value)+",<p>Your order " +(rsRMANumber.Fields.Item("PurchaseOrder").Value) + " is being shipped on " + (rsRMANumber.Fields.Item("DateShipped").Value)+ " via "+ (rsRMANumber.Fields.Item("ShippingMethod").Value)+" " + (rsRMANumber.Fields.Item("ShippingService").Value)+". Find the tracking information below:<p><strong>Date Shipped: </strong>" + (rsRMANumber.Fields.Item("DateShipped").Value)+"<br><strong>Shipping Method: </strong>"+ (rsRMANumber.Fields.Item("ShippingMethod").Value)+"<br><strong>Shipping Service: </strong>"+ (rsRMANumber.Fields.Item("ShippingService").Value)+"<br><strong>Tracking Number(s): </strong>"+ (rsRMANumber.Fields.Item("WaybillNumber").Value)+"<br>"+ (rsRMANumber.Fields.Item("WaybillNumber2").Value)+"<br>"+ (rsRMANumber.Fields.Item("WaybillNumber3").Value)+"<br>"+ (rsRMANumber.Fields.Item("WaybillNumber4").Value)+"<br>"+ (rsRMANumber.Fields.Item("WaybillNumber5").Value)+"<p>If you have any questions, comments or concerns, feel free to contact Customer Service by calling 630-238-8883.<p>Thank you for your order.</font><p><hr size=1><font size=1 face=Arial, Helvetica, sans-serif color=#999999>This email was sent to "+(rsRMANumber.Fields.Item("EmailAddress").Value)+ ", by some company.Please do not reply to the email. This mailbox is not monitored and you will not receive a response. For assistance, please contact Customer Service at 800-555-8883.</font>"
objCDOMail.Send(objCDOMailFrom, objCDOMailTo,
objCDOMailSubject, strBody, objCDOMailImportance); objCDOMail= null;
%>

[lmf232s]

You can try to format it like this

FormatDateTime(Date(), 2) = 3/15/2006

FormatDateTime( YourDate, FormatType)

Look at this web site for the FormatType: possible values 0-4

http://www.w3schools.com/vbscript/func_formatdatetime.asp