In a new assignment, Date() doesn't work. The error message is "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a number expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables". Date() worked on my home PC as well as my prior work environment. I was using Access 97 in each location. Format() doesn't work as well.

From any code page select Tools > References. Uncheck any items that say "Missing".

If Jack's suggestion doesn't work (and I think it will), replace date() with date.