CODEWITHSUNDEEP
vb.netformatting
Jack
Jack

Reputation: 10037

VB.net: Date without time

How do you format the date time to just date?

For example, this is what I retrieved from the database: 12/31/2008 12:00:00 AM, but I just want to show the date and no time.

Upvotes: 18

Views: 143992

Answers (5)

Tony Dong
Tony Dong

Reputation: 3313

Format datetime to short date string and convert back to date

CDate(YourDate.ToString("d"))

Or use short date string

CDate(YourDate.ToShortDateString)

Upvotes: 5

Rick
Rick

Reputation: 5039

I almost always use the standard formating ShortDateString, because I want the user to be in control of the actual output of the date.

Code

   Dim d As DateTime = Now
   Debug.WriteLine(d.ToLongDateString)
   Debug.WriteLine(d.ToShortDateString)
   Debug.WriteLine(d.ToString("d"))
   Debug.WriteLine(d.ToString("yyyy-MM-dd"))

Results

Wednesday, December 10, 2008
12/10/2008
12/10/2008
2008-12-10

Note that these results will vary depending on the culture settings on your computer.

Upvotes: 14

Brian Knoblauch
Brian Knoblauch

Reputation: 21359

Or, if for some reason you don't like any of the more sensible answers, just discard everything to the right of (and including) the space.

Upvotes: 1

madcolor
madcolor

Reputation: 8170

FormatDateTime(Now, DateFormat.ShortDate)

Upvotes: 37

Jon Skeet
Jon Skeet

Reputation: 1500215

Either use one of the standard date and time format strings which only specifies the date (e.g. "D" or "d"), or a custom date and time format string which only uses the date parts (e.g. "yyyy/MM/dd").

Upvotes: 37

Related Questions