The following code which I have used many times will not work on my new database.

Today.Caption = Format(Now(), "d/m/yyyy")

It gives the message

"run time error 13 Type mismatch"

The code works in other databases on this pc. Library files are the same and in the same order. I don't understand why it won't work.

I would very much appreciate some help.