Microsoft Access and Date Formating

[joolzhaines]

Hi,

I am having trouble with the format of dates comming from access, if I view a table in access with a field of Date/Time the date is formatted correctly as dd/mm/yyyy, but when I retreve the date from my ASP page the format changed to mm/dd/yyyy. I can successfully change the format using a date format function but is there a way of getting access to send the date in the correct format in the first place or know why it's doing this. I am using access 2003 and the following connection string

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\webSites\testWeb\dataBase\fcd_db_080306.mdb"

Thanks for any help and guidance you can give

Joolz

 

[Sergeant]

I haven't done this, but apparently you can use this:
Session.LCID = 2057
in your global.asa file.
See this page.

I have been using a function to fix my dates. That's pretty straight-forward as well.