Exception thrown: 'System.FormatException' in mscorlib.dll dates
/* Just putting this here for myself, but maybe it will help someone else too:
If this error occurs when you are importing data from Excel,
it is possible that your computer's regional settings are incorrect.
Try using ExactParse if in C# , and if there are still issues it may be the
Excel/ regional setting combo causing the issue.
*/
try
{
formattedDate = DateTime.ParseExact(dateString, "dd/MM/yyyy", null).ToString("yyyy-MM-dd");
}
catch
{
// Might be the wrong expected format, might be regional settings
}
Are there any code examples left?
New code examples in category C#
-
C# 2022-03-27 22:40:23 c# movement script
-
C# 2022-03-27 22:15:17 Delete last modification on EntityFramework Core
-
C# 2022-03-27 22:15:02 file.create folder c#
-
C# 2022-03-27 19:25:04 Error inflating class android.support.constraint.ConstraintLayout
-
C# 2022-03-27 19:15:02 top down shooting in unity 2D
-
C# 2022-03-27 18:50:02 c# remove invalid directory characters
-
C# 2022-03-27 18:30:07 how to use K2 games Games parallax background
-
C# 2022-03-27 18:25:10 c# replace crlf
-
C# 2022-03-27 18:25:09 keycode for left mouse click unity