Ramco Ramco

Ramco Ramco

  • 419
  • 3.4k
  • 528.3k

Excel Data Upload

Apr 4 2023 4:42 PM

Hi

  I have attached Excel file. I uploaded on shared server . 20 records got updated . On 21st record it gave error - String was not recognized as a valid DateTime. Could not store 15-04-2023 in Date Column. Expected type is DateTime. 

Server formatis - mm-dd-yy. How it is possible few records got updated and  few left. 

/forums/uploadfile/f61a1a/04042023163802PM/Sample.xlsx

When i ran on local system where format is dd-mm-yyyy it worked perfectly.

Thanks


Answers (3)