Import Excel date in a Medini column date (FMEA)

medini_1057179964

Dear all

I want to copy an excel date in a Medini column date

i use the script hereafter to translate excel date format to Medini date format

date is the date1 in excel

datevalue is to convert 45261 (in excel) to 1706111470332 (in Medini)

                datea=new java.lang.Integer(date1);

                DateValue = (datea-25569)*86400000; // (* 1000 * 60 * 60 * 24)

                recommended.user_achieved_deadline= DateValue;

But Medini don't accept my data : script message error : lang issue

Thanks in advance for your help

Best regards 

Philippe

medini_1024098885

Dear Philippe,

did you try this:

 

recommended.user_achieved_deadline = new java.lang.Long(DateValue);

Regards

Mario