P
PaulR
The last thread was getting too long so I have re-posted
I use the FP insert wizards to generate the code automatically, and do not
want to get into programming. (I want to spend my time making money not
coding!)
I have an Access database embeded in a site. It uses ASP pages to return data.
Recently my ISP provider moved from an older versin to IIS6 / Windows2003
server.
Most pages still work, but any with a date function do not.
The database now only returns certain dates, for example 10/10/2007 works,
but 01/09/2007 does not, even thougth this date has valid database entries.
The fault is reproduceable at:
http://www.derbyshiremason.org/newpglroot/masonicConcepts/calendar.asp
I have tried changing the locale to both US and GB, but this does not affect
the problem.
I have heard that date formats in IIS6 /SQL2003 have changed so that they
now have date and time.
Any ideas?
Regards
Paul
I use the FP insert wizards to generate the code automatically, and do not
want to get into programming. (I want to spend my time making money not
coding!)
I have an Access database embeded in a site. It uses ASP pages to return data.
Recently my ISP provider moved from an older versin to IIS6 / Windows2003
server.
Most pages still work, but any with a date function do not.
The database now only returns certain dates, for example 10/10/2007 works,
but 01/09/2007 does not, even thougth this date has valid database entries.
The fault is reproduceable at:
http://www.derbyshiremason.org/newpglroot/masonicConcepts/calendar.asp
I have tried changing the locale to both US and GB, but this does not affect
the problem.
I have heard that date formats in IIS6 /SQL2003 have changed so that they
now have date and time.
Any ideas?
Regards
Paul