question Re: I need to allow user only to select date after 7 days excluding business days. in Virtual Agent forum

I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Fri, 21 Mar 2025 19:37:12 GMT

Hi,

I need to allow user to select date after 7 days but it should calculate only business days not weekend. In our project as per client we follow Friday, Saturday as weekend and I need to exclude Friday, Saturday. When user select date then it should calculate for Sunday, Monday, Tuesday, Wednesday, Thursday as business day.

Can you please help me with that.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Fri, 21 Mar 2025 19:55:22 GMT

Hello @niveditakumari

Please try below code -

var startDate = new GlideDateTime("2024-03-22"); // Fixed start date
var businessDays = 7;
var daysAdded = 0;

while (daysAdded < businessDays) {
startDate.addDays(1); // Move to the next day
var dayOfWeek = startDate.getDayOfWeek(); // 1 = Sunday, 2 = Monday, ..., 7 = Saturday

if (dayOfWeek != 5 && dayOfWeek != 6) { // Exclude Friday (5) and Saturday (6)
daysAdded++;
}
}

// Print the final date in YYYY-MM-DD format
gs.info("Future Business Date: " + startDate.getValue());

I just tried it and its giving result

Kindly mark my answer helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts.

Regards,

Shivalika

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sat, 22 Mar 2025 19:01:07 GMT

Hi @Shivalika,

Can you please confirm which type of script are you using.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Sun, 23 Mar 2025 01:28:56 GMT

Hello @niveditakumari

. It can be done via any server side script only. So, business rule. When user selects the date, you can cross validate it with this script and give error message.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sun, 23 Mar 2025 12:20:40 GMT

Hi @Shivalika,

Can you please confirm which business rule and to which table do I need to write script.

Please confirm for above point.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Sun, 23 Mar 2025 12:23:08 GMT

Hello @niveditakumari

That depends on your requirement. What's your requirement ?

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sun, 23 Mar 2025 13:12:28 GMT

Hi @Shivalika,

I have catalog item and field('ABC') that is in Date/Time format. When user select date in that field it should allow only 5 business day and business day will be Sunday, Monday, Tuesday, Wednesday, Thursday.

Ex - Today is 20th March and when user select date in that field then it should allow user to select date after 5 days excluding Friday, Saturday. User can select date after 27th only it should not calculate Friday and Saturday.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sun, 23 Mar 2025 14:34:07 GMT

Hi @Ankur Bawiskar,

I have written before business rule script to allow only 5 business day in expected_date field that is in Date/Time format.

(function executeRule(current, previous /*null when async*/ ) {

// Add your code here

var expected_date = current.expected_date;

gs.info('expected date is' + expected_date);

var startDate = new GlideDateTime(expected_date); // Fixed start date

var businessDays = 7;

var daysAdded = 0;

while (daysAdded < businessDays) {

startDate.addDays(1); // Move to the next day

var dayOfWeek = startDate.getDayOfWeek(); // 1 = Sunday, 2 = Monday, ..., 7 = Saturday

if (dayOfWeek != 6 && dayOfWeek != 7) { // Exclude Friday (6) and Saturday (7)

daysAdded++;

}

// Print the final date in YYYY-MM-DD format

gs.info("Future Business Date: " + startDate.getValue());

})(current, previous);

I need to abort action when user select date before 5 Business day.

Can you please help me with above and correct that.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Sun, 23 Mar 2025 14:36:58 GMT

Hello @niveditakumari

So it is q catalog item, in that case, you can use On load or On change client script with a Script include and Glide Ajax. In there you can use the script I passed.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sun, 23 Mar 2025 18:52:40 GMT

Hi @Ankur Bawiskar,

Can you please help me with above script.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Sun, 23 Mar 2025 18:56:11 GMT

Hello @niveditakumari

The script provided above by me is working.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for my efforts and also it can move from unsolved bucket to solved bucket

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Sun, 23 Mar 2025 19:00:24 GMT

And @niveditakumari for what you are asking you can just use on submit catalog client script with ajax.

With business rule you will need to use Display business rule and scratchpad object, and then set abort section, but passing it to catalog. You will ultimately need to use something that's provided for catalog - like on submit client script, return false and it will do the job. If it was some records business rule wouldn't be an issue. That's the reason I asked requirement. Even now BR is not issue, but it's not optimal solution.

However you can go by only business rule as you prefer or as Ankur says.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Sun, 23 Mar 2025 20:00:49 GMT

Hi @Shivalika,

Thank you for your reply.

I got your solution but you hasve mentioned in your previous previous use onload or onchange client script becausde of that I got confused and in other community post I saw that to use business rule. I just need clarification which will be best approach.

Now you are saying I can use onsubmit and abort action by return false.

function onSubmit() {

//Type appropriate comment here, and begin script below

var expected_date = g_form.getValue(expected_date);

var startDate = new GlideDateTime(expected_date); // Fixed start date

var businessDays = 7;

var daysAdded = 0;

while (daysAdded < businessDays) {

startDate.addDays(1); // Move to the next day

var dayOfWeek = startDate.getDayOfWeek(); // 1 = Sunday, 2 = Monday, ..., 7 = Saturday

if (dayOfWeek != 6 && dayOfWeek != 7) { // Exclude Friday (6) and Saturday (7)

daysAdded++;

}

}(current, previous);

Do I need to add anything in above onSubmit client script.

Can you please see attached screenshot and confirm that it is correct.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Mon, 24 Mar 2025 07:38:38 GMT

Hi @Shivalika,

Can you please help me with that.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Mon, 24 Mar 2025 07:39:55 GMT

Hi @Ankur Bawiskar,

Do I need to do any changes.

Can you please correct that.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Mon, 24 Mar 2025 07:43:16 GMT

Hello @niveditakumari

Actually all the client scripts will work. And as I said business rule would be best option if it wasnt catalog. Because with catalog you only have client scripts and UI policies that will directly work on it. So to interact with server side, you need Ajax. There's no way out.

So, rhe script is already here, now to tailor it to your requirement exactly. What do you wanna do ? Do you want to restrict the form submission of user hasn't selected a date that is within the range ? What is the exact steps you want to take - error field message? Can you share your catalog form screenshot ?

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

Ankur Bawiskar — Mon, 24 Mar 2025 08:05:27 GMT

@niveditakumari

do you have a schedule which has that holidays?

If yes then use this link to add 7 days using schedule, compare that date against user given using GlideAjax and then throw error

Add Business Days

sharing some links which can help you

Variable Date no less than 5 business days

Auto-populating and validating date fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: I need to allow user only to select date after 7 days excluding business days.

niveditakumari — Mon, 24 Mar 2025 08:38:00 GMT

Hi @Shivalika,

I have catalog item and in that I have field ABC when user select date in that field then it should calculate 5business day. Today is 24th March and in my field when user select tomorrow date then it should show field error message that please select date after 5 business days, when user select 29th March then it should show same field error message because Friday, Saturday comes under as weekend, when user select 31st then it should not show field error message because it is completing it's 5business day.

Hope you are clear with my requirement.

Can you confirm what step Do I need to follow to achieve that.

Regards,

Nivedita

Re: I need to allow user only to select date after 7 days excluding business days.

Shivalika — Mon, 24 Mar 2025 08:53:55 GMT

Hello @niveditakumari

Please use below on change Client script on your expected date field. Please change the field names with whatever you are using on the form.

function onChange(control, oldValue, newValue, isLoading) {

if (isLoading || newValue == '') {

return;

}

var startDate = g_form.getValue('start_date'); // Get the Start Date

if (!startDate) {

return;

}

// Call Script Include to calculate the correct Expected Date

var ga = new GlideAjax('CalculateBusinessDate');

ga.addParam('sysparm_name', 'getBusinessDate');

ga.addParam('sysparm_start_date', startDate);

ga.addParam('sysparm_user_selected_date', newValue);

ga.getAnswer(function(correctExpectedDate) {

if (correctExpectedDate && correctExpectedDate !== newValue) {

g_form.showFieldMsg('expected_date', 'Invalid Expected Date. Adjusted to the next valid business day.', 'error');

g_form.setValue('expected_date', correctExpectedDate); // Auto-correct the date

}

});

}

Below script include - make sure to check the Client Callable checkbox there.

var CalculateBusinessDate = Class.create();

CalculateBusinessDate.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getBusinessDate: function() {

var startDate = this.getParameter('sysparm_start_date');

var userSelectedDate = this.getParameter('sysparm_user_selected_date');

if (!startDate || !userSelectedDate) {

return '';

}

var validExpectedDate = this.calculateExpectedDate(startDate); // Get the correct business date

var userDate = new GlideDateTime(userSelectedDate);

var userDayOfWeek = userDate.getDayOfWeek(); // 1 = Sunday, ..., 7 = Saturday

// If user-selected date is Friday (6) or Saturday (7), return the correct expected date

if (userDayOfWeek == 6 || userDayOfWeek == 7 || userDate.getValue() !== validExpectedDate.getValue()) {

return validExpectedDate.getValue();

}

return userSelectedDate; // If correct, return the same date

calculateExpectedDate: function(startDate) {

var businessDays = 7;

var daysAdded = 0;

var calculatedDate = new GlideDateTime(startDate); // Start from given Start Date

while (daysAdded < businessDays) {

calculatedDate.addDays(1);

var dayOfWeek = calculatedDate.getDayOfWeek(); // 1 = Sunday, ..., 7 = Saturday

if (dayOfWeek != 6 && dayOfWeek != 7) { // Skip Friday (6) & Saturday (7)

daysAdded++;

}

return calculatedDate;

}

});

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket.

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Re: I need to allow user only to select date after 7 days excluding business days.

SANDEEP28 — Mon, 24 Mar 2025 10:32:47 GMT

Hi @niveditakumari

For your requirement you can use OnSubmit catalog client script using GlideAjax and client callable script include.

I have created "Expected Date" field in catalog item for demo. Below client script and script include code is working.

You can also use this onChange client script along with onSubmit client script for better user experience.

OnSubmit Client script -

Script include -

As Ankur Said, if you have schedules created then you can check links provided by Ankur,

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!