i get 1900-01-01 in my sql serverhow to get real date ?

Question

when i click the button the date that the server receive is 1900-01-01.how to get real date from the useri'm using DateTimePicker in vb.net..can anyone help...do i have to do any code or formathow?

Upendra Pratap Shahi · Answer

Hi Use like this- Private Sub DateTimePicker1_ValueChanged(sender As Object e As EventArgs) Handles DateTimePicker1.ValueChanged ' When the datepicker1 has changed (date has been chosen).. do something with that date ' Get the datepicker's chosen day name Dim dayOfWeek As String = DateTimePicker1.Value.DayOfWeek.ToString() ' Update the label to show the user Label4.Text = dayOfWeek ' Now change the content shown according to the date range ContentChanger(dayOfWeek) End Sub Sub ContentChanger(dayOfWeek As String) If dayOfWeek = Monday Then StatusLabel1.Text = USstatus StatusLabel1.ForeColor = Color.Blue StatusLabel5.Text = DownloadStatus StatusLabel5.ForeColor = Color.Green StatusLabel6.Text = DownloadStatus StatusLabel6.ForeColor = Color.Green End If End Sub

Upendra Pratap Shahi · Answer

This is universal format of time i.e. 'yyyy-MM-dd' in which format do you want date?

Upendra Pratap Shahi · Answer

Your welcome King Umar and many thanks for appreciation.

King Umar · Answer

many thanks Upendra (Y)

King Umar · Answer

yesi want that format.how to put itjust click at the datetimepicker on the vb form right?

i get 1900-01-01 in my sql server,how to get real date ?