How to convert date format in vb.net?

by

Assuming you want to convert the xml string value to a proper DateTime variable, Net has many methods for this:

' a date value in the string format specified:
Dim xmlDate As String = "07/15/2014 7:07:33 AM"

' create a DATE variable from that string in a known format:
Dim newDate As Date = DateTime.ParseExact(xmlDate, "MM/dd/yyyy h:mm:ss tt",
           Globalization.CultureInfo.InvariantCulture)

Once you have am actual date variable, you can display it in any format required. Doing so does not change the underlying date value, it just changes the output style:

Dim myDt As DateTime = DateTime.Now

Console.WriteLine(mydt.ToString("dd MMM yy HH:mm tt"))
Console.WriteLine(mydt.ToString("MM/dd/yyyy h:mm:ss"))

DateTime types are a value; they do not have a format. Formats are for how we display data to humans (as with .ToString() above) and how we tell DataTime the pattern to expect when parsing text data from humans into a DateTime variable.

You must be careful when using many of the VB functions. Some do not create date types at all, just new string variables. CDate can be especially problematic when using date strings from other cultures . It assumes the string is in the current culture format, which may not be the case. This can lead to 08/07/yyyy converting to 07/08/yyyy.

From original question:
I am getting xml response date format string is "MM/dd/yyyy h:mm:ss a"

From comment:
xml returning date format is "7/8/2014 12:00:00 PM"

The format specified in the question does not match the example posted in the comment. The xmlDate text is in fact in M/d/yyyy format, not MM/dd/yyyy! Using ParseExact means we are giving DateTime the exact format to expect. When the format does not match the actual string pattern, it will fail:

Dim actualDate As Date
Dim xmlTest As String = "7/8/2014 12:00:00 PM"

actualDate = DateTime.ParseExact(xmlSource, "MM/dd/yyyy h:mm:ss tt",
                                 Globalization.CultureInfo.InvariantCulture)

This will fail because the text is not in MM/dd format. Note that "M/d" can parse dates from strings in the pattern of "MM/dd" because some days and months will be 2 characters (“10/20…”). But the reverse is not true: “MM/dd” will require the leading 0. Specify the correct format and you wont get a format exception:

 actualDate = DateTime.ParseExact(xmlSource, "M/d/yyyy h:mm:ss tt",
                                 Globalization.CultureInfo.InvariantCulture)

ParseExact is probably the best approach here, because it appears you are importing data from elsewhere. For simple data validation of user input, Parse or TryParse are usually enough. These will try to parse the text using any of the format patterns defined for the current culture.

Some cultures have well over 100. This means the user can input date data almost anyway they want and your code can still parse/convert it to a DateTime type.

See DateTime.ParseExact for more information.

More Related Contents:

  1. What do Option Strict and Option Explicit do?
  2. Clean up Excel Interop Objects with IDisposable
  3. Reference variables and objects elsewhere in a form
  4. “There is already an open DataReader…” Reuse or Dispose DB Connections?
  5. Parse Delimited CSV in .NET
  6. Using related data stored in a 2 dimensional array
  7. How do you parse an HTML in vb.net
  8. Is the Microsoft.VisualBasic namespace “true .NET” code?
  9. The proper way to dispose Excel com object using VB.NET?
  10. How do you get a string from a MemoryStream?
  11. Measuring code execution time
  12. How do I convert an Excel serial date number to a .NET DateTime?
  13. Why can’t DateTime.ParseExact() parse “9/1/2009” using “M/d/yyyy”
  14. Searching values via a datagridview
  15. Getting the path of the current assembly
  16. Which is generally best to use — StringComparison.OrdinalIgnoreCase or StringComparison.InvariantCultureIgnoreCase?
  17. How do I create an event handler for a programmatically created object in VB.NET?
  18. How do I shuffle and deal cards one at a time to players?
  19. SqlDateTime.MinValue != DateTime.MinValue, why?
  20. What is the correct format to use for Date/Time in an XML file
  21. BitmapImage in WPF does lock file
  22. .NET DateTime.Now returns incorrect time when time zone is changed
  23. Does End Using close an open SQL Connection
  24. Does this code prevent SQL injection?
  25. Option Strict On and .NET for VB6 programmers
  26. Analyze colors of an Image
  27. Deserialize using JSON.net
  28. Cause this VB6-like smell, which VB.NET allows, to error instead: WinFormType.InstanceProp=Value [DISABLE My.Forms]
  29. Pass Command Line to first instance of a Single Instance App
  30. How to print datagridview table with its header in vb.net?

Leave a Comment