Need help with the script to calculate the duration between 2 dates

Rohit8 · ‎01-05-2018

Hello,

Wish you all a very Happy New Year.

I am trying to build an Indicator to calculate the Summed age of Assets (to later find out the Average age). The asset table has the columns for Release Date and Retired Date and I need to calculate their difference. The screenshot (A) has the format of the dates.

The 2nd screenshot has the script screen and I am using the above variables. I am not proficient with scripts at all so I am pretty sure I am doing something totally wrong.

var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};

var years=function(x,y){return diff(x,y)/(365*24*60*60*1000);};

years(current.u_avg_hw_release_date, current.retired_date_at);

The job returns the error:

Error during JavaScript evaluation com.snc.pa.dc.ScriptException: JavaScript evaluation returned: NaN in script: var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};

var years=function(x,y){return diff(x,y)/(365*24*60*60*1000);};

years(current.u_avg_hw_release_date, current.retired_date_at);

at com.snc.pa.dc.Script.handleException(Script.java:215)

at com.snc.pa.dc.Script.evaluate(Script.java:179)

at com.snc.pa.dc.Script.evaluate(Script.java:156)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:261)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:214)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:172)

at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:246)

at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:162)

at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:147)

at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:103)

at com.glide.schedule.JobExecutor.execute(JobExecutor.java:89)

at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:219)

at com.glide.schedule.GlideScheduleWorker.lambda$process$39(GlideScheduleWorker.java:161)

at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)

at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:161)

at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:72)

Caused by: java.lang.Exception: JavaScript evaluation returned: NaN

... 15 more

Can anyone help me correct the script or let me know what am I doing wrong.

Thanks a lot.

Thilo Grobe · ‎01-06-2018

Last try

var sgd1 = new GlideDate();   

var sgd2 = new GlideDate();   

sgd1.setDisplayValue(current.retired.getDisplayValue());   

sgd2.setDisplayValue(current.u_abg_hw_release_date.getDisplayValue());   

var duration = GlideDate.subtract(sgd1, sgd2);   

Math.floor(duration.getDayPart()/365);

Cheers,

Thilo

View solution in original post

Rohit8 · ‎01-06-2018

Thank you Thilo.

Yes, indeed. I realized that later and replaced it with correct field names, Your script worked perfectly and returns the correct difference (in days) when I test it with the Sys_ID in Scripts - Background.

So now, Does it have to be added as it is to Scripts. I did that after editing the 2nd line from your code "gr.get('00a96c0d3790200044e0bfc8bcbe5dc3');", since that SysID was an example. At first I tried it with the 2nd line entirely removed:

I received the below error right away in Data Collector, after running the job.

Error during JavaScript evaluation com.snc.pa.dc.ScriptException: JavaScript evaluation returned: Undefined in script: var gr = new GlideRecord('alm_hardware');

var sgd1 = new GlideDate();

sgd1.setDisplayValue(gr.retired.getDisplayValue());

var sgd2 = new GlideDate();

sgd2.setDisplayValue(gr.u_avg_hw_release_date.getDisplayValue());

duration = GlideDate.subtract(sgd1, sgd2);

gs.addInfoMessage(duration.getDayPart());

at com.snc.pa.dc.Script.handleException(Script.java:215)

at com.snc.pa.dc.Script.evaluate(Script.java:176)