date() and now() don't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of a sudden all my report dates don't work. It used to use NOW() for
today's date. I've tried everything to insert today's date and nothing
works. I have no idea why. Help!
 
What is it giving you instead - an error or the wrong date?

If it's the wrong date, it's because your computer's date is wrong.
If it's an error, it isn't typed in as =Now() or =Date(). Something else
must be in there, or the = is missing.
 
See the 2/18 @ 8:28 pm post by Rick -- fredg's response points to a problem
with MISSING references. When standard functions (like Date() and Now()
don't work, it's usually because a reference has been lost/unlinked.

It rarely happens spontaneously, so is there a chance you are working on a
different PC, or with a machine that's been recently updated, or ...
 
Back
Top