inserts dates into ms-acces databse : how can i write the right syntex to insert date to my database


this the sql command that i already tried:

    "insert into table1 (date) values (#"+DateTime.Parse(DateTime.Now.ToShortDateString())+"#)"

also that:

    "insert into table1 (date) values ('"+DateTime.Parse(DateTime.Now.ToShortDateString())+"')"