Dear Experts

I have applied following custom Format to DateTimePicker

dd-MM-yyyy

So now DateTimePicker is displaying data as

15-01-2010

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.