String was not recognized as a valid DateTime.why?

Question

while i am trying to fetch datetime data from db it shows the error String was not recognized as a valid DateTime. code: Model: public DateTime? ReviewedDate{get;set;} Controller: DateTime? ReviewedDate = null; if (testordervm.ReviewedDate != DateTime.MinValue) { ReviewedDate = DateTime.Parse(dsobj.Tables[0].Rows[0][ReviewedDate].ToString()); } else { ReviewedDate = null; }

Željko Perić · Answer

The DATE value that You are fetching from data base is not in valid DateTime format so the DateTime.Parse method returns error message. Try to use : MessageBox.Show(dsobj.Tables[0].Rows[0][ ReviewedDate ].ToString()); to check what are You trying to parse to date and time. Perhaps the value returned from db is null or the value is not in correct DateTime format that could be changed by formatting string to recognizable date time format: ReviewedDate = DateTime.Parse(dsobj.Tables[0].Rows[0][ ReviewedDate ].ToString(dd.MM.yyyy)); Here is url where You can learn all about Standard Date and Time Format Strings and Custom formatting. https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings All the best Željko Peric