How to convert datetime string in format MMMdyyyyhhmmtt to datetime object?

by

Alexei’s answer is quite right, I wanna explain little bit deep if you let me..

You are thinking 5 should match with d specifier, right? But this is not how DateTime.ParseExact works under the hood.

Since The "d" custom format specifier represents number from 1 through 31, this specifier will map 52 in your string, not just 5. That’s why your code throws FormatException.

As you can see, your string format can’t parsed unless you do it some string manipulations with it.

In such a case, .NET Team suggests either using two digit forms like 05 or insert separators for your date and time values.

You can create a custom method that parse this MMMdyyyyhhmmtt format for only parse this kind of formatted strings like;

public static DateTime? ParseDate_MMMdyyyyhhmmtt(string date)
{
    if (date == null)
        return null;
    if (date.Length < 14)
        return null;
    if (date.Length == 14)
        date = date.Insert(3, "0");
    DateTime dt;
    if (DateTime.TryParseExact(date, "MMMdyyyyhhmmtt",
                               CultureInfo.InvariantCulture,
                               DateTimeStyles.None, out dt))
        return dt;
    return null;
}

More Related Contents:

  1. How do I get the correct time in C#
  2. Days between two dates in asp.net
  3. Convert DateTime to Date string “dd/mm/yyyy”
  4. How do I calculate someone’s age based on a DateTime type birthday?
  5. Parse string to DateTime in C#
  6. How to truncate milliseconds off of a .NET DateTime
  7. Calculate the number of business days between two dates?
  8. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  9. Find if current time falls in a time range
  10. How to compare DateTime in C#?
  11. How do I loop through a date range?
  12. How to Validate a DateTime in C#?
  13. How do I convert an ISO8601 TimeSpan to a C# TimeSpan?
  14. Parse datetime in multiple formats
  15. How do I get the time difference between two DateTime objects using C#?
  16. Why DateTime.AddHours doesn’t seem to work?
  17. DateTime format to SQL format using C#
  18. How to convert Javascript datetime to C# datetime?
  19. How to find the 3rd Friday in a month with C#?
  20. How can I format a nullable DateTime with ToString()?
  21. How does DateTime.ToUniversalTime() work?
  22. Converting string format to datetime in mm/dd/yyyy
  23. why does DateTime.ToString(“dd/MM/yyyy”) give me dd-MM-yyyy?
  24. datetime to string with time zone
  25. Where’s the DateTime ‘Z’ format specifier?
  26. Getting time span between two times in C#?
  27. C# date formatting is losing slash separators
  28. Set Default DateTime Format c#
  29. Adding a Time to a DateTime in C#
  30. Specify Date format in MVC5 (dd/MM/yyyy)

Leave a Comment