Converting dd/mm/yyyy formatted string to Datetime [duplicate]

by

You need to use DateTime.ParseExact with format "dd/MM/yyyy"

DateTime dt=DateTime.ParseExact("24/01/2013", "dd/MM/yyyy", CultureInfo.InvariantCulture);

Its safer if you use d/M/yyyy for the format, since that will handle both single digit and double digits day/month. But that really depends if you are expecting single/double digit values.

Your date format day/Month/Year might be an acceptable date format for some cultures. For example for Canadian Culture en-CA DateTime.Parse would work like:

DateTime dt = DateTime.Parse("24/01/2013", new CultureInfo("en-CA"));

Or 

System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
DateTime dt = DateTime.Parse("24/01/2013"); //uses the current Thread's culture

Both the above lines would work because the the string’s format is acceptable for en-CA culture. Since you are not supplying any culture to your DateTime.Parse call, your current culture is used for parsing which doesn’t support the date format. Read more about it at DateTime.Parse.

Another method for parsing is using DateTime.TryParseExact

DateTime dt;
if (DateTime.TryParseExact("24/01/2013", 
                            "d/M/yyyy", 
                            CultureInfo.InvariantCulture, 
                            DateTimeStyles.None,
    out dt))
{
    //valid date
}
else
{
    //invalid date
}

The TryParse group of methods in .Net framework doesn’t throw exception on invalid values, instead they return a bool value indicating success or failure in parsing.

Notice that I have used single d and M for day and month respectively. Single d and M works for both single/double digits day and month. So for the format d/M/yyyy valid values could be:

  • “24/01/2013”
  • “24/1/2013”
  • “4/12/2013” //4 December 2013
  • “04/12/2013”

For further reading you should see: Custom Date and Time Format Strings

More Related Contents:

  1. Convert a string to date format
  2. Converting a String to DateTime
  3. Parse string to DateTime in C#
  4. Convert string to DateTime in c#
  5. How to convert DateTime to/from specific string format (both ways, e.g. given Format is “yyyyMMdd”)?
  6. Parse C# string to DateTime
  7. DateTime conversion from string C#
  8. Convert string to datetime Using C#
  9. De-serializing json format string
  10. How to add a char every X specific char in C# [closed]
  11. Parse DateTime with time zone of form PST/CEST/UTC/etc
  12. Using C# to check if string contains a string in string array
  13. How do I read a specified line in a text file?
  14. Best way to repeat a character in C#
  15. DateTime “null” value
  16. Measuring code execution time
  17. Get the index of the nth occurrence of a string?
  18. C# Double – ToString() formatting with two decimal places but no rounding
  19. How to convert a UTF-8 string into Unicode?
  20. What’s so bad about building XML with string concatenation?
  21. Best way to split string into lines
  22. C# String replace with dictionary
  23. How can I put quotes in a string?
  24. Format date in C#
  25. Convert String to Date in .NET if my incoming date format is in YYYYMMDD
  26. DateTime “null” / uninitialized value?
  27. Why doesn’t VS 2008 display extension methods in Intellisense for String class
  28. Extract only right most n letters from a string
  29. Specify Date format in MVC5 (dd/MM/yyyy)
  30. what’s the use of string.Clone()?

Leave a Comment