Integration

Hi,

We use a lot of templates and people are copy/pasting from other files into the templates. Unfortunately it cauases problems. EDQ does not always recognize the real date but only the excel serial number for the date. Ofcourse, we need to structually resolve this by looking at the processes/settings. But for now, I would like to build a quick fix.

How can I convert Excel serial number dates (type: string) to normal dates (type: date). I've used google and seen a couple of basic Javascript coding that will do the job, but these won't work properly in EDQ.

For example a basic code:

function ExcelDateToJSDate(serial) {
   var utc_days = Math.floor(serial - 25569);
   var utc_value = utc_days * 86400;                                        
   var date_info = new Date(utc_value * 1000);

   var fractional_day = serial - Math.floor(serial) + 0.0000001;

   var total_seconds = Math.floor(86400 * fractional_day);

   var seconds = total_seconds % 60;

   total_seconds -= seconds;

   var hours = Math.floor(total_seconds / (60 * 60));
   var minutes = Math.floor(total_seconds / 60) % 60;

   return new Date(date_info.getFullYear(), date_info.getMonth(), date_info.getDate(), hours, minutes, seconds);
}

Thanks for helping out and pointing me in the right direction.