Validating a Date Field Against a Customizable Future Date Range
Requirement:
In ServiceDesk Plus, there may be scenarios where you want to ensure that a user-selected date (through a request UDF field) falls within a valid range — for example, not in the past and not beyond 1 year, 6 months, or a certain number of days from today.
This can be enforced using a Field and Form Rules script.
Steps to Implement:
-
Create two additional date fields and add them to the request template to capture the start and end dates.
-
Navigate to Request Template > Field and Form Rules > On Form Submit, and click New to create a new rule.
-
Paste the provided script into the rule and update it with your specific additional field details. Refer to the comments within the script for guidance.
Script:
- // ===== Configuration =====
- var startDate = "WorkOrder_Fields_UDF_DATE1"; // Replace with start Date - field name
- var endDate = "WorkOrder_Fields_UDF_DATE2"; // Replace with end Date - field name
- var allowedYears = 1; // Set to 0 if not using
- var allowedMonths = 0; // Set to 0 if not using
- var allowedDays = 0; // Set to 0 if not using
- // ==========================
- var startDate_val = $CS.getValue(startDate);
- var endDate_val = $CS.getValue(endDate);
- // var maxAllowedDate = new Date(); // if its from Current Date.
- var maxAllowedDate = startDate_val; // if its from a Start Date.
- // Add allowed duration
- maxAllowedDate.setFullYear(maxAllowedDate.getFullYear() + allowedYears);
- maxAllowedDate.setMonth(maxAllowedDate.getMonth() + allowedMonths);
- maxAllowedDate.setDate(maxAllowedDate.getDate() + allowedDays);
- // Validation
- if (endDate_val > maxAllowedDate) {
- $CS.showInfo("Please select a date within the allowed limit!", { "type": "failure" });
- $CS.setValue(endDate, new Date()); // Reset to today
- }
New to ADSelfService Plus?
Related Articles
Query to find out the users added on a specific date range
This should be handy during Audit. Execute the query nder Reports->New Query Report Users added based on a date range. Here the range is from and to today. select * from aaauser where createdtime >= <from_today> AND CREATEDTIME <= <to_today> If ...How to disable the Created Date field for technicians
1. Roles Under Admin >> Roles >> Disable the below access The above option will disable the user from modifying Created Date, Resolved Date, Dueby Time. 2. Field and Form Rules If the requirement is to disable only Created Date field. Under Admin >> ...Script to Update Date additional field (to 3 days) based on priority inside the request
In some cases the customer will need to update the date additional field based on priority set inside the request. (Applicable for builds 14300 & above) Please follow the below mentioned steps to configure: First Download and extract the attached zip ...How to diff of two Date& Time fields using FAFR
If you have two date and time additional fields or default fields, and if you want to capture the difference between those two fields in Hours and minutes, then use the below script to capture the value in an additional field, Under the respective ...Script to Update date/time additional field inside request when note is added.
(Applicable for builds 14300 & above) Please follow the below mentioned steps to configure: First Download and extract the attached zip file containing the scripts & attachments (screenshots) 1.Goto Admin > Developer space --> Custom Functions > ...