Unanswered: VB6's Date problems while using on XP.
I am writing a transactions ledger using VB6 and access 2000. I've done all the querying on windows 2000. now that i switched to windows XP, all the querys that worked on 2000 are generating errors on XP.
One observation i've found is in 2000 the date is taken as "dd/mm/yyyy" where the seperator is "/". while in XP its taking it as "dd.mm.yyyy". I tried using the "format" function and changing it to "/" but it generates an "overflow" error. Could someone plz help in solving this problem.