Copy link to clipboard
Copied
I am trying to add a particular number at regular intervals
I have difference between 2 dates in hours
so for first 24 hours result 1 ,
even more than a minute to 24 hours >> result 1+.5 = 1.5 ,
then again even more than a minute to next 8 hours >> result 1.5 + .5 = 2
then again even more than a minute to next 16 hours >> result 2 + .5 = 2.5
then again even more than a minute to next 8 hours >> result 2.5 + .5 = 3
then again even more than a minute to next 16 hours >. result 3 + .5 = 3.5 and so on.
In short .5 to be added after 24 hours for at every more than 8 hours & 16 hours
I am using the below script but not able to achieve the above :
var miles = this.getField("minutes").value; //difference between days in minutes
var hrs = Math.floor(miles/(60*24)); //capturing the hours part
var min = miles%60 //capturing the remainder minutes
if(hrs == "0" && min > 0){event.value =1}
else if (hrs >0 && min >0) {event.value = hrs + ".5"}
else if (hrs > 0 && min == "0"){event.value = hrs}
Found the correct script after doing lot of permutation and combination.
Below is the script:
var miles = this.getField("Diff_Minutes").value; //Difference between 2 dates in Minutes
var nDays = Math.floor(miles/(60*24)); //Capturing the full Days
var rHours = Math.floor(miles/60) - (nDays*24); //Capturing the full hours remaining after full Days
var rMinutes = miles%60; //Capturing remaining minutes after capturing full days & hours
event.value = 0;
if(nDays <= 0 && (rMinutes > 0 || rHours >
...
Copy link to clipboard
Copied
Remove the double-quotes around all the numbers.
Copy link to clipboard
Copied
same thing.. not working as per requirement even after removing the ""
Copy link to clipboard
Copied
Either share the file or be more specific about what "not working" means, exactly...
Copy link to clipboard
Copied
Copy link to clipboard
Copied
I can't see any calculation at the field "Result".
Copy link to clipboard
Copied
script is already provided in my original post...you can copy it and change the field name
i removed the script from result as to avoid any confusion......you can write script from scratch or edit my script to meet the condition mentioned in the pdf file
Copy link to clipboard
Copied
Found the correct script after doing lot of permutation and combination.
Below is the script:
var miles = this.getField("Diff_Minutes").value; //Difference between 2 dates in Minutes
var nDays = Math.floor(miles/(60*24)); //Capturing the full Days
var rHours = Math.floor(miles/60) - (nDays*24); //Capturing the full hours remaining after full Days
var rMinutes = miles%60; //Capturing remaining minutes after capturing full days & hours
event.value = 0;
if(nDays <= 0 && (rMinutes > 0 || rHours > 0) ){event.value = 1};
if(nDays == "1" && rMinutes == "0" && rHours == "0"){event.value = 1}
if(nDays >=1 && rMinutes == "0" && rHours == "8"){event.value = nDays + .5}
if(nDays >= 1 && rMinutes > 0 && rHours >= 8 ){event.value = nDays + 1};