How Can I Insert Dates Here..

See more:

VB

let me explain i have 4 column in a table test_no(autogenerate),test_date(text),test_cycle_No(number),test_day(number)


so now the problem is test no as i said is autogenerating ,test_cycle_no and test_day this two column value are already in database ,but i have to generate and insert date column value externalyy...

i have written code for generating date values
but i want that this date values should be inserted here in this table ,consisting of all this columns.
so what query should i write ????