jahntech, many thanks for prompt replies..now it is showing 6 working
days if a person leaves on 1 apr 2018 and back to work on (Date2) 8 apr
2018.i want it to show 5 days and two weekend days (Fri and Sat) ....
keep in mind that Date2 is joining date which means that the total days
should subtract one day from the joining date.could you please help?
Want to get total days from two dates Date1Date2the total days should
exclude weekends "Fridays" and "Saturdays"I'm pushing the script in
properties of the Total field.could anybody check if I'm doing something
wrong because the calculation is not showing the correct number.the code
is given below:// get the end date valuevar Date2 =
this.getField("Date1").value;// get the start date valuevar Date1 =
this.getField("Date2").value;var dDate1 = util.scand("dd/mmm/yyyy",
Date1);var dDate2 =util.scan...