Confused with Date()

[RADM]

Hi,

In some of my access 2k reports, I've used date() to print current date. Some other reports, I used now() to get the same output as before. While using Date(), it gives #Name error but works fine with Now(). Even Access common expression also promots date(). Why it is so?

Regards,

RADM

 

[Craig0201]

It's a bug. You've got something wrong with your VBA references which causes this bug to appear. Have a look and you'll probably see a missing library. Either reinstall that library or delete the reference if your code doesn't need it.

Craig