Hi there...

I have a "date/time" field in my Access db. I`ve set it to "Default Value = Now()". And it get`s by default the date and the time.

What I want to do is to insert in this field only the 'date value' without the 'time value'. Is this possible?

Setting the default value to Date() should do what you want.

HTH,

Chris

 Which format did u set in the database date/time field?

use Date() function if it is mm/dd/yy format otherwise
ise FormatDateTime() function to insert to that format.


--------------
Rajani