Now and Current Date

[Guest]

Hi Everybody,

I am using Access as a frontend and SQL Server as a backend for a
registration form on a website. I want to have a field that automatically
puts the current date of when a person registers into the table. In Access,
I use the expression Now() to declare the date as the default value. If I
put Now() into the same field as the default value for the backend database,
I receive syntax errors.

Is Now() the correct code to place into the default value or is there
something else?

Thank you in advance,

Matt

 

[=?iso-8859-1?Q?J=F6rg_Ackermann?=]

I am using Access as a frontend and SQL Server as a backend for a
registration form on a website. I want to have a field that
automatically puts the current date of when a person registers into
the table. In Access, I use the expression Now() to declare the date
as the default value. If I put Now() into the same field as the
default value for the backend database, I receive syntax errors.

Is Now() the correct code to place into the default value or is there
something else?

GETDATE()

Acki

 

[Guest]

Thanks!!

GETDATE()

Acki