how to remove time from datetimepicker in vb.net ?

Question

how to remove time from datetimepicker in vb.net when display in the listview,i'm using vb.net and microsoft visual studio,i just want to display "8/19/2015" without the "12:00 AM" (time),any idea guys,anyone have experience on this?

Rafnas T P · Answer

change datetimepicker format to short

Rafnas T P · Answer

remove all Do_Date from database and re add dates without time, for this in vb make datetimepicker format to short and save.then check

Rajeesh Menoth · Answer

Hi, Ref the following links: 1) remove time in datetimepicker 2) How to remove time section from date time picker? 3) Change appearance of date time picker

Rajeesh Menoth · Answer

Hi, DTPicker1. Value = Format ( DTPicker1. Value , "mm/dd/yyyy" )

Venkateshwar Reddy · Answer

you can do this in multiple ways one is from DB, refer the below snippet. select convert(varchar(20),Date_ColumnName,101) as [Date] from Database_Name Other one is from VB Code. ' />

Anel Hodzic · Answer

Is your database field type "datetime" or just "date" ? . All you need to do is format your datetime to desired output. You can read from your database to listbox and loop through listbox items and format each.

Akhil Kumar · Answer

before you add value to listview format it to your desired. like Dim Strdate as String Strdate=Format( DTPicker1. Value , "MM/dd/yyyy") ListBox1.Items.Add(Strdate) hope this helps.

Umesh bhatia · Answer

Dim dt As date = DateTime.Now ListBox1.Items.Add(dt.ToShortDateString) Or try dt.ToString("dd/MM/yyyy")

Rafnas T P · Answer

remove all Do_Date from database and re add dates without time, for this in vb make datetimepicker format to short and save.then check

King Umar · Answer

still not working,any idea guys?

how to remove time from datetimepicker in vb.net ?

Answers (10)