How can I parse dates with a suffix “th”, “st” or “nd” on the day of the month?

by

There isn’t anything inbuilt in .Net framework to parse dates in format of January 11th or February 22nd etc. You have to remove the suffix characters and then you can use DateTime.TryParseExact.

For dates with Suffix st, th, you can use string.Replace to remove that part and then use DateTime.TryParseExact. Like. 

string str = "1st February 2013";
DateTime dtObject;
string replacedStr =  str.Substring(0,4)
                         .Replace("nd","")
                         .Replace("th","")
                         .Replace("rd","")
                         .Replace("st","")
                         + str.Substring(4);


if (DateTime.TryParseExact(replacedStr, 
                            "dd MMMMM yyyy", 
                            CultureInfo.InstalledUICulture, 
                            DateTimeStyles.None, 
                            out dtObject))
{
 //valid date
}

For multiple formats, you can specify the formats in a string array and later you can use that. It returns a bool value indicating if the parsing was successful or not.

Example from MSDN:

string[] formats= {"M/d/yyyy h:mm:ss tt", "M/d/yyyy h:mm tt", 
                   "MM/dd/yyyy hh:mm:ss", "M/d/yyyy h:mm:ss", 
                   "M/d/yyyy hh:mm tt", "M/d/yyyy hh tt", 
                   "M/d/yyyy h:mm", "M/d/yyyy h:mm", 
                   "MM/dd/yyyy hh:mm", "M/dd/yyyy hh:mm"};
string[] dateStrings = {"5/1/2009 6:32 PM", "05/01/2009 6:32:05 PM", 
                        "5/1/2009 6:32:00", "05/01/2009 06:32", 
                        "05/01/2009 06:32:00 PM", "05/01/2009 06:32:00"}; 
DateTime dateValue;

foreach (string dateString in dateStrings)
{
   if (DateTime.TryParseExact(dateString, formats, 
                              new CultureInfo("en-US"), 
                              DateTimeStyles.None, 
                              out dateValue))
      Console.WriteLine("Converted '{0}' to {1}.", dateString, dateValue);
   else
      Console.WriteLine("Unable to convert '{0}' to a date.", dateString);

More Related Contents:

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

Leave a Comment