MS Access and ASP : DATE Format failure

Sebastiaan · September 30th, 2003, 07:14 AM

Hi,

Can someone please tell me whether it is possible to copy the format of a field instead of the basic data ?

e.g. I use a DATE/TIME Data Type in MS Access with a Long Date format but when I use objRS("Date") on an ASP page, I simply get 30/09/2003 instead of "Monday, September 30, 2003".

Is there a way we can set an option in ASP, ADO or MS Access to get the data right ? Thanks for yor advice.

Sebastiaan.

sankar · October 1st, 2003, 05:53 AM

Quote:

quote:Originally posted by Sebastiaan
Hi,

Can someone please tell me whether it is possible to copy the format of a field instead of the basic data ?

e.g. I use a DATE/TIME Data Type in MS Access with a Long Date format but when I use objRS("Date") on an ASP page, I simply get 30/09/2003 instead of "Monday, September 30, 2003".

Is there a way we can set an option in ASP, ADO or MS Access to get the data right ? Thanks for yor advice.

Sebastiaan.

Hi Sebastiaan,
Use FormatDateTime(objRs("Date"),1) instead of simply objRs("Date") to get the desired output. FormatDateTime is a VB Script function.
HTH
Cheers!

Sankar Sengupta

Sebastiaan · October 1st, 2003, 12:32 PM

Sankar, thanks for your help, this function works fine, very easy to use

Seb.