How to convert 10/10/20 6:05 into 10/10/2020 06:05

See more:

C#

ASP.NET

WebForms

MS-Excel

I have a problem with my project ,

I have to convert datetime from excel using eppplus with this format " 10/10/20 6:05"

when i try to convert it ,it shows error like this

"

System.FormatException: String was not recognized as a valid DateTime.

"

how can i solve this?

this is my code

What I have tried:

protected void check(object sender, EventArgs e)
       {
           if (FileUpload1.HasFile)
           {
               string filename = "Hr_Report_" + DateTime.Now.ToString("dddd_dd_MMMM_yyyy") + ".xlsx";
               FileUpload1.SaveAs(temp_file + filename);
               string tempfile = temp_file + filename;
               string c = @tempfile;
               DataTable table = new DataTable();

               FileInfo existingFile = new FileInfo(tempfile); //+ FileUpload1.FileName);
               using (ExcelPackage package = new ExcelPackage(existingFile))
               {
                   ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
                   int colCount = worksheet.Dimension.End.Column;
                   int rowCount = worksheet.Dimension.End.Row;
                   table.Columns.Add("Emp_NIK", typeof(string));
                   table.Columns.Add("Date_Finger", typeof(DateTime));
                   table.Columns.Add("Time_Finger", typeof(string));
                   table.Columns.Add("Status", typeof(string));

                   for (int i = 1; i < rowCount; i++)
                   {
                       TableRow row = new TableRow();
                       TableCell cell1 = new TableCell();
                       string tanggal = worksheet.Cells[i + 1, 2].Text.ToString();
                       string employee_id = worksheet.Cells[i + 1, 1].Text.ToString();
                       string status = worksheet.Cells[i + 1, 3].Text.ToString();
                       DateTime y = Convert.ToDateTime(tanggal);
                       finger.InsertData(employee_id, "null", status, y, "test ricki");
                   }
               }
           }
           else
           {
               Response.Write("<script>window.alert('File Belum diupload')</script>");
           }
       }