Now and Current Date

M

Matt

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
 
J

Jörg Ackermann

Matt said:
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?
Click to expand...

GETDATE()

Acki
 
Top