How to Calculate Date Range Exclude Weekend & Public Holiday In Malaysia Calendar
Confluence User - 31 May, 2021
Hi, I have a task to make the calculation date range whici is Exclude Weekend & Public Holiday. Is that possible to that in joget? Here is the basic coding that include public & weekend. Appreciate your help.
$('input[name="fromDatepicker"], input[name="toDatepicker"]').change( function(){ d1 = $('input[name="fromDatepicker"]').datepicker('getDate'); d2 = $('input[name="toDatepicker"]').datepicker('getDate'); diff = 0; if (d1 && d2) { diff = Math.floor((d2.getTime() - d1.getTime()) / 86400000); // ms per day } $('input[name=days]').val(diff);});
Thanks.
forms;datalists;server;user;userviews