Date field validation

Nipan — Wed, 02 Apr 2025 10:49:34 GMT

Hi,

User can Select 5 days from today excluding weekend (Saturday, Sunday).

I have written a UI policy, which is working for - "Start date should be 5 days from today in future"

The above script is working correctly but it's including (counting) weekend also (Saturday, Sunday).

Need help to exclude weekend and count 5 days (weekdays).

Thanks,

Nipan

Re: Date field validation

SriharshaYe — Thu, 03 Apr 2025 12:48:22 GMT

Hi @Nipan ,

We can achieve this using UI Policy Script or a Client Script that automatically updates a field with the calculated number of weekdays excluding weekends i.e saturday and sunday

Using UI Policy Script

write the script as below :

function onCondition() {

var startDate = g_form.getValue('u_start_date');

var endDate = g_form.getValue('u_end_date');

// convert start and end date to objets

var start=new Date(startDate);

var end = new Date(endDate);

var weekdaysCount = 0;

// Ensure the end date is not before the start date

if (start > end) {

return;

}

for (var currentDate = new Date(start); currentDate <= end; currentDate.setDate(currentDate.getDate() + 1)) {

var dayOfWeek = currentDate.getDay(); // Get the day of the week (0 = Sunday, 6 = Saturday)

// Check if it's a weekday (Monday to Friday)

if (dayOfWeek >= 1 && dayOfWeek <= 5) {

weekdaysCount++;

}

g_form.setValue('u_weekdays', weekdaysCount);

}

The above script calculates the weekdays , excluding weekends.

Using Client Script.
create a new onchange client script as below
The above Script calculates the weekdays and excludes the weekends

question Re: Date field validation in Virtual Agent forum