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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Property sheet data missing also syntax 0
Excel How to get the number of days an item was opened from the today's date. 14
Date as a value to a textbox as a result from another textbox 1
date stamp to keep date 2
Problem using Date() for default value in my Date/Time field 4
Changing a Date Time Value 2
How to put a Date into SQLServer (.NET) 2
Problems formating date 1

Back
Top