Date() vs. Now()

[pamela]

I utilize both Access 97 and Access 2000. Somehow the
Date() function does not work in 97. Actually that's not
true. It views normally on my machine, but the users that
only have 97 only see an error message. Now() works, but I
can't format it not to show the time within a field. I
believe it is because I have both programs on my computer.

Any suggestions?

 

[John Crighton]

Hi Pamela,

Try DateValue(Now())

HTH

John C

 

[Rick Brandt]

I utilize both Access 97 and Access 2000. Somehow the
Date() function does not work in 97. Actually that's not
true. It views normally on my machine, but the users that
only have 97 only see an error message. Now() works, but I
can't format it not to show the time within a field. I
believe it is because I have both programs on my computer.

Any suggestions?

The app includes a reference setting that cannot be resolved properly on the
machines where Date() is not working. BTW there are likely a bunch of other
functions that won't work either so substituting Now() is not a solution.

On a PC that exhibits the problem open a code window (or press Ctl-G) and then
go to Tools - References. In the resulting dialog examine the references that
are "checked" and see if any have the word "Missing" after them. If so, then
try unchecking those and see if the app will compile. If it does you should be
good to go and should find that Date() works correctly.

If the app will not compile then that means you have code somewhere that needs
the removed reference. Sometimes you can go back into Tools - References and
re-check the same item and everything will still work. If not, then either that
library must be fixed (registered properly) or the code that relies on it must
be removed so the reference can be deleted.