[MIKE2098]

I want to add a date field to my table I have tried [Date] datetime but it resets to Date or [Date]]]

I have a simple table

USERS

userID Int NOTNULL
Email VarChar NOTNULL
Date datetime NOTNULL

Driving me mad I just want a date/time to be added when a userID and email address is added.

I am ussing VB 2005 SQL Express/MSSMSE on Vista x64

or do I just need to create a table as it defaults too and add code to generate date

i.e.

Dim date1 As DateTime
date1 = Now()
TextBoxDate = date1

thanks M

[PsychoCoder]

If you are just wanting to default your column to the current datetime use GETDATE()

[MIKE2098]

PsychoCoder, on 5 May, 2008 - 06:10 AM, said:

If you are just wanting to default your column to the current datetime use GETDATE()

Sorry where do I use GETDATE() in the table or on the form ?

thanks

[PsychoCoder]

If you want it to default to the current date, in Enterprise Manager where it says Default Value for that column in that table (right click on the table and select Design) then select that column, down below will be a Default Value section, add GETDATE() on that line.

[MIKE2098]

PsychoCoder, on 5 May, 2008 - 06:36 PM, said:

If you want it to default to the current date, in Enterprise Manager where it says Default Value for that column in that table (right click on the table and select Design) then select that column, down below will be a Default Value section, add GETDATE() on that line.

Thanks for that I knew it was somthing simple.

how would I query the db to see if the user id is already in the DB ?

Is there a way to run aselect statement that will output to a text file or even better an email with the results and a way of flagging the DB so if a user details have been stored or sent it will not send them again

somthing like

select email/date from Users where date > 4400

not sure if this is a VB or sql question sorry

thanks

This post has been edited by MIKE2098: 06 May 2008 - 01:37 AM