Date Format Issue (ASP/Access)

[SISCAN]

I have a problem when updating a date into a MS Access database on my WEB Server; my local date format is DD/MM/YYYY yet when my ASP script updates to the WEB server database the format is MM/DD/YYYY.

I have set the session variable for Canada "session.lcid=4105"

I have proven the ASP script is obtaining the date from the form in a correct format Response.Write works fine on the Web Server.

Any help would be appreciated.

 

[gmmastros]

I suggest you try the ISO format YYYY-MM-DD. This should always be interpretted properly by Access.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SISCAN]

George

I will try that and report back.

Barry