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
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
,"DD/MM/YY"
