how to specify the default value for a field as todays date and time

  • Thread starter Thread starter garyusenet
  • Start date Start date
G

garyusenet

Using VB Express and SQL.

I have an sql database. what function gives me todays date and time?
and do i enter it in the 'default' property for the column in the
database?

i've tried
now()
date()
date$()
dateandtime
all give me an error message - what am i doing wrong?

thanks,

GARY.
 
Back
Top