Date (1 Viewer)

[accessman2]

Hi,

I want to create the date column in the SQL Server table, but, I don't want the user the user to populate the date, I want the system automatically populate the date when the user input the values on other fields.

When I create date column, there are Formula, and Default values.

I tried to put Now() in the formula, but it is illegal.

What function I can use over there?

 

[FoFa]

I think, on the Sql Server table itself, in that column def. you can specify a default value of GetDate() and if no date is supplied on an insert, it will default to the current date/time