How do I Convert Default Values in ACCESS to SQL 1

[nrugado]

I have some field level default values that were in my MS Access Tables. I am now entering those into the field level default values in the SQL tables and I am getting errors for a few of them.

They have to do with the smalldatetime field and me trying to use

Date() and Now()

as I had used in MS Access. Does anyone have any insight as to what I will need to use in SQL to get field level defaults to work?

 

[SQLSister]

Getdate() gives you the current date.