I have read Excel file by Node js using npm: read-excel-file. But the date format is a float data type. I have tried many ways but some days it works and some do not. Incorrect date example below variable _num
Please help me !!!
var _num = 44211.425405092596; // Here Excel Date data is true : 15/01/2021 10:12:16 SA but code return is : 2021-1-18 6:5:49 convertDateExcel(_num); function convertDateExcel (__Date) { var splitDate =String(__Date).split('.'); var _Date = new Date(1900, 0, splitDate[0]-1, 0, 0, Math.round(splitDate[1]/1157410)).getTime()/1000 const milliseconds = _Date * 1000 const dateObject = new Date(milliseconds) var month = dateObject.getUTCMonth() + 1; var day = dateObject.getUTCDate(); var year = dateObject.getUTCFullYear(); var time = dateObject.getHours() + ":" + dateObject.getMinutes() + ":" + dateObject.getSeconds(); console.log( year + "-" + month + "-" + day + " time : " + time) //return year + "-" + month + "-" + day + " " + time; }
没有评论:
发表评论