Unknown Date Function
Posted on 2011-02-25
I have a field in my database called "ActionDate", in the design of the table the default value I have set to "Date()" - I want the field to automatically populate with todays date when a record is created.
Words great on my computer but when I try to run the application on another computer in the office it comes up with this error: "Unknown function 'Date' in validation expression or default value on "tblActions.ActionDate"
What is the better way to assign today's date to a field upon record creation to avoid this issue?