how to convert DateTime in short date and short time



Dear all,

I want to save my data into MS Access database Table which consist of some fields with short date and short time formats.
I try to save data in to the said table and I am getting error that my SQL statment is not correct.


string strSQL = @"INSERT INTO Activities ( Task,Day,Start,Finish ) VALUES ( '"+id+"', '"+date+"', '"+start+"', '"+finish+"' )" ;

I think error is because i am not able to cast my variables correctly.

how can i convert my DateTime to short date and short Time formats???

regards,

Omer kamal
.