Access 2000 & IIS 4

[IndyGill]

Im not to sure if im in the right forum for this one but here goes anyway. I have an IIS 4 Web server which has a Microsoft Database on it.

I have an ASP web page which inputs a date into the Database. When I input the date from my ASP page dd/mm/yy and then recall it from the Database the date has been converted to yy/mm/dd.

However if Access inputs a date into the database automatically it is fine. I have checked my ASP page several times and its OK. The whole thing works fine on my local machine which is running PWS

So I am guessing something is going wrong when data is passed inbetween my web page and the Access DB. I am running MDAC 2.6 as I thought it might be an ADO problem.

I have run out of ideas and I could really do with some help!!

Many thanks in advance

Indy

 

[jebry]

Hi!

I don't know if this is the problem or not, but you could check the regional settings on the web server to see how the date styles are set on that computer.

hth
Jeff Bridgham

 

[zink421]

Format the date before you display it with the format function -> format([fieldname], "dd/mm/yy&quot before you put it on the ASP page, or format it in the table field property settings. I dont think its ADO, I would say its your DB changing the format.

Jason