ACC97: DATE function now returns a "type mismatch"

[AlanKW]

ACC97 DATE function now returns a "type mismatch"

In a production system, the DATE function has stopped working. This line which worked yesterday now does not.
[tt]If PendedDate = Null Or IsDate(PendedDate) = False Then PendedDate = date[/tt]

There were no changes to the server or to the desktops. The NOW function still works. The DATE function works in other databases.

The references loaded are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Excel 9.0 object Library

(we use Access97 and office 2000)


Another database that has the same references but Word instead of Excel

Please advise

 

[AlanKW]

[red]STUPID HUMAN TRICKS[/RED]

I foolishly and mistakenly saved a module with the name DATE. Once I renamed that, it worked....

Hope someone learns from my pre-caffeine stupidity