ms access-vb date insert

[guru511]

hi,
can u plz tell me how to insert date in to msaccess

i have
text1.text=date
what is the sql statement for inserting

insert into table_name (datecolumn) values ('"+text1.text+"')

this is showing error... plz check with this.. urgent...

[elanch]

hi!
just try with this command.

text.text=now()

[guru511]

hi.. thanq...
while retriving itz showing the prob...

text1.text=now()
update table_name where t_date='"+text1.text+"'

here itz showing data mismatch

[jbennet]

thats because text1.text is a string and t_Date is probably something else (date/time?)

[QVeen72]

Hi,

u have to use this synatx in AccessSQl :

insert into table_name (datecolumn) values (#" & text1.text & "#)

or

insert into table_name (datecolumn) values (Cdate(" & text1.text & "))

Regards
Veena