Re: Date() function



Actually, either works fine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Damian S" <DamianS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:461EDD34-7815-445D-A123-6855B5046598@xxxxxxxxxxxxxxxx
Hi PLD,

In the table default value, you need to use =Date() not Date() for the
default value

Damian.

"PLD" wrote:

Access 2000 SP3

When I use the date() as a default in a date field for default I get an
error when I save the table. Unknown function'Date' in validation
expression
or default value in <table name>. Any ideas???


.