hi dear



i am new to vb.net , and i want to add date and time (DateTimePicker1) to my form

then when i save the record a wrong date is saved to the table , my database is sql 2005





Code: " & Format(DateTimePicker1.Value, "dd/mm/yy") & ") "



Result: 1/1/1900 12:00:00 AM



i much liked to help.............


amaan

not sure if this is right

DateTimePicker1.Value.ToString("dd/mm/yy")

you will probably do better posting in the Visual Basic .NET forum

hi



i had tried this code



DateTimePicker1.Value.ToString("dd/mm/yy")



but still not solved to my problem and producing same result:1/1/1900 12:00:00 AM

for any time to save record.



i hope help




amaan

You can do something like this

In design time you can change the format to Short Date

Format(DateTimePicker1.Value, "dd/MM/yy")

 

Hope this helps

how about

Convert.ToDateTime(DateTimePicker1.Value)

 

EDIT: Never mind...I just noticed the date.