asp & access sql date problems

[iono]

i have an asp application using an access 98 mdb that runs fine using pws on my machine where the short date settings are set to either 01/01/01 or 01/01/2001

however the following happens when running the app on an nt server (where regional settings short date is dd/MM/yy (eg. 17/10/01)

when i post 19/10/01 or 19/10/2001 the date is appearing as 01/10/2019 when i open ms access and look at the table - none of my code appends the '20'

any ideas ?

 

[tlbroadbent]

On his website, Allen Browne provides an excellent explanation of the problems with dates in MS Access and reasons for those problems. The article at the following link should help you understand what you need to do.

http://wa.apana.org.au/~abrowne/ser-36.html

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.