date differences??

[jc98]

when i insert the date into an Access DB from an ASP form it formats as a medium date(3-Oct-01) but the recordset returns 10/3/01.

why is this and is there a way to return the exact value from the db.

thanks,
--jc

 

[JohnYingling]

I believe the date is stored as the number seconds (milliseconds) fron a some date. All the rest of what you see is default formatting.

http://www.VBCompare.com

http://www.VBSortGen.com

 

[Cheech]

Break the date into an array and return the vallues in what ever format you wish Live long and make your kids suffer..