What version of Office are you using? What Service Pack are you at, and
then what service pack level is your user at? I remember in Access that
Date() was not a supported function in the initial release, but then
Service Pack 1 fixed it. Databases that had worked fine in Office 97
using the Date() function stopped functioning in an Access 2000
database.