[sabinsunny]

Hi team,

how to calculate year month and day from two different date in processmaker 3.1

i have two fields 1) date of joining and second one is date of leaving and this function should be triggered after pressing the calculate button

[salman1538]

Hello,

Use below code to get difference:

Code: Select all

$startDate = @@joiningDate;
$endDate = @@leavingDate;
$sDate = strtotime($startDate);
$eDate = strtotime($endDate);
$difference = ($eDate - $sDate) / 86400;   // it will return total no of days 

[amosbatto]

You can use salmon1538's PHP code if needing the difference in days in a trigger. If you want the number of whole days, then use this:

Code: Select all

@@difference = (int) (($eDate - $sDate) / 86400);

If you need to calculate the difference in days between two dates in JavaScript, then you can use the following code:

Code: Select all

function calculateDiff(joinDate, leaveDate) {
  if (joinDate == '' || leaveDate == '') {
    $("#difference").setValue('');
  }
  else {
    var daysDiff = moment(leaveDate).diff(moment(joinDate), 'days')
    $("#difference").setValue(daysDiff);
  }
}

$("#joinDate").setOnchange(function(newVal, oldVal) {
  calculateDiff( newVal, $("#leaveDate").getValue() );
});
    
$("#leaveDate").setOnchange(function(newVal, oldVal) {
  calculateDiff( $("#joinDate").getValue(), newVal );
});

In this form:

DifferenceBetweenTwoDates.png (8.96 KiB) Viewed 3978 times

Here is the DynaForm to import to try out this code:

Difference Between Dates.json

(4.56 KiB) Downloaded 311 times

[whoahedi]

Hi amosbatto,
thanks for the answer. I have download your attached form and it works on my workspace.
Still curious, where should I input the given code? I have tried to open the variable / formula / sql but couldn't find where did you put the code.

Im about couple days installing PM

[ziadeh]

Welcome to PM world.
You can read more about using javascript in PM: https://wiki.processmaker.com/3.1/JavaS ... _DynaForms

Also I prefer that you read this book:
Business Process Automation with ProcessMaker