Converting data into datetime from excel RRS feed

  • Question

  • User2023935253 posted


    From the excel sheet I read a cell data and converting it to datetime datatype. It reports specified cast is invalid error. Because, the cell data contains the value 43449. Thats why it caused the error. But when I convert this cell into date format in excel sheet then the value changed to 15-12-2018. Then I upload the excel sheet it ran successfully. My question is, how that integer value is related to this date. Is it possible to do the same logic in the code itself, coz the data is like that only for most of the excel documents.


    Monday, February 11, 2019 5:14 PM

All replies