I am ussing SQL Express and VB 2005 on Vista x64

I am trying to create a simple table with

userID double
email Varchar
date (datetime)

so when a new record is added it is timestamped in the database I have tried ussing [Date] but it either resets to Date or [Date]]] neither insert a date into the database. I need to use the date time for a query to be run that will email all the email addresses from the last 24 hrs

so I need help with the date and also is there a way of of using a timer to query the database and send and email

thanks