Issue with calculating difference between two dates

[mattgr]

HI,

I use BS rule to calculate data between two variables:

calDateDiff();  
 
  function calDateDiff(){  
  var startDate = current.variables.gdpr_received_date;  
  var endDate = current.variables.gdpr_actualcomp_date;  
current.business_duration = gs.calDateDiff(startDate,endDate,false);
  }

The first date is:

The second one is:

Why on ear SNow calculate this Business duration as:

Any idea?

[Sam Scott1 · Accepted solution]

gs.dateDiff will calculate the total duration between two dates, wheras calDateDiff will calculate the Business Duration as it relates to some defined calendar (hence cal in the function name). If you want the total difference, use gs.dateDiff. If you want a business duration, adjust the calendar in your instance until it matches your business operation schedule. Note, there are distinct fields on all task records for Duration (calendar_duration) and Business Duration (business_duration).

[Musab Rasheed]

Hello,

Below thread has solution.

https://www.servicenow.com/community/developer-forum/calculate-the-of-months-between-two-date-fields...

[Saurav11]

Hello @mattgr 

What type of field is Business duration?