how to remove time from datetimepicker in vb.net ?

King Umar

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?

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Venkateshwar Reddy10y ago
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 Hodzic10y ago
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 Kumar10y ago
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 bhatia10y ago
Dim dt As date = DateTime.Now
ListBox1.Items.Add(dt.ToShortDateString)

Or try
dt.ToString("dd/MM/yyyy")
Rafnas T P10y ago
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
Rafnas T P10y ago
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 Menoth11y ago
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
King Umar11y ago
still not working,any idea guys?
Rajeesh Menoth11y ago
Hi,
DTPicker1.Value = Format(DTPicker1.Value, "mm/dd/yyyy")
Rafnas T P11y ago
change datetimepicker format to short