String was not recognized as a valid DateTime format

Question

Hi

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

Sachin Singh · Answer

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

Jagjit Saini · Answer

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

Muhammad Imran Ansari · Answer

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" ));

Jagjit Saini · Answer

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

Sachin Singh · Answer

for start date StartDate = DateTime.ParseExact(DT1, "dd-MM-yyyy HH:mm" , null);

Jagjit Saini · Answer

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