Calculate business days duration between 2 date fields

[Priyanka145]

Hi,

How to Calculate business days duration between 2 date fields

[Priyanka145]

Hi @Ankur Bawiskar ,

As I have used String data type to store the duration(difference between 2 date fields), I am getting the value in the format of 1 day 2 hours 3 minutes 4 seconds.

But for reporting purpose, we need it in numeric format . Could you please guide me it is possible ?

I have even tried by creating a new field of duration type and try to set, but I am unable to set the value to duration type field.

[MR1]

This script was in the BR or scheduled job?

Where did we wrote this script and what was the type of fields getting populated?

Thanks

[Saurav11]

Hello Priyanka,

If you want to calculate difference between two dates and also have schedule to follow you can use the below, it will return the value in milleseconds.

var dc = new DurationCalculator();
dc.setSchedule('sysidoftheschedule');
var time = dc.calcScheduleDuration(date1,date2);

Please mark answer correct/helpful based on Impact.

[Priyanka145]

Hi Saurav,

As I am checking for the difference of 2 dates excluding holidays, I have written below script, where in I got something like below

    var start= new GlideDateTime(date1);
     var end= new GlideDateTime(date2);
   
    var dc= new DurationCalculator();
    dc.setSchedule('f4db82011b36a010cb721f42b24bcb27');
     var time = dc.calcScheduleDuration(start,end);
   gs.log(time);

In the log, I got 907200(milliseconds), but where in my date1 is 15-06-2022 07:54:37 and date2 is 24-07-2022 14:02:37. Considering there is no holiday in between this and my schedule is 8 am - 5 pm excluding holidays, it should be 27 days right? How to convert to number of days and also let me know if I am missing anything?

[Saurav11]

Hello,

As Ankur pointed out the 907200 is seconds and is basically the business days which refers to the only the time taken between the schedule defined and the day will be calculated accordingly.

Thanks.