I have an existing Db that when I enter Date()in default value, it says it doesn't recognize the function Date.  I tried making a new table within this same db and tried it - same thing. I open up PCResale and it works no problem.  My db began in Access 2003 and the data resides on a server.

---

Reply from Richard Rost:

That's odd. Have you tried creating a NEW database? Make sure you have:

=DATE()

And not just Date() or =Date in the field. Either SHOULD work, but the official command is =Date()

If none of that works, your older database may have a reference to a library missing, which is a pain to fix. Make a NEW blank database and then import the objects from the old one into the new shell.