This is a multi-part message in MIME format.

------=_NextPart_000_005F_01C167DD.B70F9690
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Use FormatDateTime(rsSQLResult.Fields("MyDate"))

Enzo
  ----- Original Message -----
  From: bmcelhany@h...
  To: sql language
  Sent: Tuesday, November 06, 2001 9:55 PM
  Subject: [sql_language] formatting date returned from sql server


  When I display a date/time field on an ASP page that is the result of 
a
  SQL query, the date always is displayed as something like: Mon Jan 1
  00:00:00 PST 2001. How do I get it to display as something like 
1/1/2001?

  By the way, I am doing my ASP coding using JavaScript, so I'd like to 
stay
  away from any VBScript solutions if possible.

  Thanks in advance!

  Brian

$subst('Email.Unsub')