Dates

[Guest]

My database,Access97,has hundreds of recods with dates and amount. It gives
me totals of last week compared to this week etc . It is in a network drive.
Recently I changed my computer. If I use this databse on any other computer,
the results are OK. When I use my new computer I get wrong results. What
could be wrong?

 

[Douglas J. Steele]

Is there any pattern to the errors?

How are you calculating the totals?

 

[Guest]

Dates are picked from text boxes named e.g LastWeek and ThisWeek

Strange part is that it is working on other computers but not my (new)
computer. It was working ok with my old computer. The shortcut points to the
same database.
Coud it be the date setup on my computer?
BUT... the text boxes show the correct date....

 

[Joseph Meehan]

My database,Access97,has hundreds of recods with dates and amount. It
gives me totals of last week compared to this week etc . It is in a
network drive. Recently I changed my computer. If I use this databse
on any other computer, the results are OK. When I use my new computer
I get wrong results. What could be wrong?

Look to make sure your computer's clock is correct and has the current
date. Also make sure your computer's regional settings are set to the same
country as the others.

 

[Guest]

Computer date and regional settings are OK. My dates are picked up from a
text box input and possibly does not pick it from the computer date.