String was not recognized as a valid DateTime format

Jagjit Saini

I am trying to upload data but it is giving above error

DateTime StartTime = DateTime.Now;String Time = colum[2].ToString();String DT1 = colum[1].ToString() + " " + Time;DateTime StartDate = DateTime.ParseExact(DT1, "dd-MM-yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture);StartTime = Convert.ToDateTime(StartDate.ToString("yyyy-MM-dd HH:mm"));

Below is the Excel Data

col1	Col2	Col3
13	01/04/2022	14:30
18	02/04/2022	16:00
13	03/04/2022	17:15

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jagjit Saini4y ago
Hi Muhammda

I am inporting Data frim Excel
I cannot write - String Time = "14:30";
Currently it is showing as 31/12/1899 14:30 . It should show only 14:30

Thanks
+1
Muhammad Imran Ansari4y ago
In your excel sheet your date format is '03/04/2022', there are '/' between the values, same use '/' in date format. use the following code:
DateTime StartTime = DateTime.Now;
String Time = "14:30"; //colum[2].ToString();
String DT1 = "01/04/2022" + " " + Time; // "01/04/2022" = colum[1].ToString()
DateTime StartDate = DateTime.ParseExact(DT1, "dd/MM/yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture);
StartTime = Convert.ToDateTime(StartDate.ToString("yyyy/MM/dd HH:mm"));
+1
Jagjit Saini4y ago
Hi sachin

Same Error
In DT1 it shows 01/04/2022 00:00:00 14:30 . IT should show 01/04/2022 14:30
In time also it shows as 31/12/1899 14:30

DateTime StartTime = DateTime.Now;
String Time = colum[2].ToString();
String DT1 = (colum[1].ToString()) + " " + Time;
DateTime StartDate = DateTime.ParseExact(DT1, "dd-MM-yyyy HH:mm", null);
System.Globalization.CultureInfo.InvariantCulture);
StartTime = Convert.ToDateTime(StartDate.ToString("yyyy-MM-dd HH:mm"));

Thanks
+1
Sachin Singh4y ago
for start date
StartDate = DateTime.ParseExact(DT1, "dd-MM-yyyy HH:mm", null);
+1
Jagjit Saini4y ago
Hi

Error is coming on StartDate i think so

Error - Cannot implicitly convert type string to string.date.time

StartTime = Convert.ToDateTime(StartDate).ToString("yyyy-MM-dd HH:mm");

Thanks
+1
Sachin Singh4y ago
use this
StartTime = Convert.ToDateTime(StartDate).ToString("yyyy-MM-dd HH:mm") ;
+1