question how to achive this requirement can any one help me in ITSM forum

how to achive this requirement can any one help me

damodar — Wed, 22 Oct 2025 11:40:50 GMT

Desired Date Requested"

Mandatory
Date
- Users should not be able to add the current day or next day 2 days and should only be able to select business days only
Map to Due Date field

Re: how to achive this requirement can any one help me

glideFather — Wed, 22 Oct 2025 14:50:13 GMT

Hi @damodar,

please provide more details, is it a variable on a form on a portal or backend form?

For backend you can achieve this with UI Policy and for Portals with Catalog UI Policy.

Example on my variable on a portal form:

or onSubmit Catalog Client Script.

Let me know how does it look and what you think about this.

Re: how to achive this requirement can any one help me

damodar — Thu, 23 Oct 2025 06:24:11 GMT

should only be able to select business days only

Re: how to achive this requirement can any one help me

damodar — Thu, 23 Oct 2025 16:21:02 GMT

This is the script include i wrote

var ValidateCatalogDate = Class.create();

ValidateCatalogDate.prototype = Object.extendsObject(AbstractAjaxProcessor, {

isValidDate: function () {

var inputDateStr = this.getParameter('sysparm_date');

var scheduleName = this.getParameter('sysparm_schedule_name'); // remove this line

if (!inputDateStr || !scheduleName){

return 'false'; //remove || !scheduleName from this line

}

var inputDate = new GlideDate();

inputDate.setValue(inputDateStr);

var minDate = new GlideDate();

minDate.addDaysUTC(3);

if (inputDate.compareTo(minDate) < 0){

return 'false';

}

var dayOfWeek = inputDate.getDayOfWeek();

if (dayOfWeek == 1 || dayOfWeek == 7) {

return 'false';

}

var scheduleId = '55ebbbf15f002000b12e3572f2b47714';

var spanGR = new GlideRecord('cmn_schedule_span');

spanGR.addQuery('schedule', scheduleId);

spanGR.addQuery('start_date', '<=', inputDateStr + ' 23:59:59');

spanGR.addQuery('end_date', '>=', inputDateStr + ' 00:00:00');

spanGR.setLimit(1);

spanGR.query();

if (spanGR.next()){

return 'false';

}

return 'true';

type: 'ValidateCatalogDate'

});

this is the client script i wrote

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

if (isLoading || !newValue) return;

var dateField = 'desired_date_requested'; // This should be newValue instead, or g_form.getValue('desired_date_requested')

var selectedDate = new Date(newValue + 'T00:00:00');

var today = new Date();

today.setHours(0, 0, 0, 0);

var msPerDay = 24 * 60 * 60 * 1000;

var diffDays = Math.floor((selectedDate - today) / msPerDay);

if (diffDays <= 2) {

g_form.showFieldMsg(dateField, 'You cannot select today or the next two days.', 'error');

g_form.setValue(dateField, '');

return;

}

var ga = new GlideAjax('ValidateCatalogDate');

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

ga.addParam('sysparm_date', newValue);

ga.addParam('sysparm_schedule_name', 'U.S. Holidays'); //remove this line

ga.getXMLAnswer(function (response) {

if (response === 'false') {

g_form.showFieldMsg(dateField, 'Invalid date: Must be a business day (not a weekend or holiday).', 'error');

g_form.setValue(dateField, '');

g_form.setValue('due_date', '');

} else {

g_form.hideFieldMsg(dateField, true);

g_form.setValue('due_date', newValue);

}

});

}
but it's not working

Re: how to achive this requirement can any one help me

glideFather — Fri, 24 Oct 2025 08:50:16 GMT

Hi @damodar,

no problem with that:

Thank you for accepting my response as solution

Re: how to achive this requirement can any one help me

Ankur Bawiskar — Fri, 24 Oct 2025 08:55:03 GMT

@damodar

what do you mean by business day?

For some customers Saturday and Sunday are business days and for some others it's not.

you can use GlideSchedule in your onChange + GlideAjax

check these 2 links

Variable Date no less than 5 business days

Auto-populating and validating date fields

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: how to achive this requirement can any one help me

MaxMixali — Fri, 24 Oct 2025 10:17:35 GMT

✅ Requirement: Restrict Date Field and Map to Due Date

Users should not be able to add:
- The current day or next 2 days
- Weekends (Saturday, Sunday)
They should only be able to select business days, and the selected date should map to the Due Date field.

--------------------------------------------------------------------
🧩 Implementation Steps
--------------------------------------------------------------------

Step 1: Create the Date Variable / Field
----------------------------------------
- Variable name: u_due_date
- Type: Date
- Mandatory: true

Step 2: Add Catalog Client Script (onChange)
--------------------------------------------
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}

var selectedDate = new Date(newValue);
var today = new Date();

// Remove time
today.setHours(0, 0, 0, 0);
selectedDate.setHours(0, 0, 0, 0);

// Calculate difference in days
var diffDays = Math.floor((selectedDate - today) / (1000 * 60 * 60 * 24));

// Restrict current and next 2 days
if (diffDays <= 2) {
alert("Please select a date at least 3 business days from today.");
g_form.clearValue('u_due_date');
return;
}

// Restrict weekends
var day = selectedDate.getDay();
if (day == 0 || day == 6) {
alert("Weekends are not allowed. Please select a business day (Monday–Friday).");
g_form.clearValue('u_due_date');
return;
}

// Map to Due Date field
g_form.setValue('due_date', newValue);
}

--------------------------------------------------------------------
Step 3: Use for Standard Forms (Optional)
----------------------------------------
Create a Client Script on the table (e.g., Task, Incident) with same logic.

--------------------------------------------------------------------
Step 4: Optional Enhancement
----------------------------------------
You can extend validation to check official holidays via a Script Include referencing cmn_schedule_span.

--------------------------------------------------------------------
✅ Expected Behavior
| Scenario | Result |
|-----------|---------|
| Today | ❌ Alert |
| Tomorrow / +2 days | ❌ Alert |
| Weekend | ❌ Alert |
| Valid business day (+3) | ✅ Accepted, auto-mapped to Due Date |