Dear Experts

I have applied following custom Format to DateTimePicker


So now DateTimePicker is displaying data as


Sql server 2005, table1 has column named Date with datetime type

How to store DateTimePicker text into date column of Table1

I want to save only date not time as 15-01-2010

Please help

when i do this, my database columns for date use the YYYY-MM-DD format.
you can make yours whatever you like

INSERT INTO table_name ( DATE ) VALUES ( " & vb6.format$(now() "YYYYMMDD") & " )

hope that helps