Catalog variable Date/Time validation – 2 working days (Sun–Thu) with hour‑based lead time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wednesday
Hi Community,
I’m working on a Service Catalog Date/Time variable validation and would like confirmation or suggestions for improvement.
Variable Details
- Variable name: time_to_send_out_comms
- Variable type: Date/Time
- Used on: Service Request (SR)
Business Requirement1. Past Date/Time Validation
- The selected date/time must not be in the past
✅ If user selects a past date/time, show the error message:
“The time chosen to send out the communication occurs in the past, kindly select a future date/time to proceed.”
2. Minimum Lead Time – 2 Working Days (Hour‑Based)
- The selected date/time must be at least 2 working days after the current date/time
- Working days: Sunday to Thursday
(Friday and Saturday are non‑working days) - Lead time must be hour‑based, not just date‑based
Example
Current date/time:
13/May/2026 13:05:00 (Wednesday)Thank you✅ Valid selections
- 17/May/2026 13:06:00
- 17/May/2026 15:00:00
- Any date/time after the same HH:mm:ss on the 2nd working day
❌ Invalid selections
- 17/May/2026 13:04:00
- Any date/time before 17/May/2026 13:05:00
✅ If user does not allow 2 working days lead time, show the error message:
“Please allow two working days lead time for approvals and content review.”
Please provide with exact code so it will helpful to me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@Vishal Jaswal ,
Thank you for your response. I have given same code which you have given :
Please check If I'm missing anything in onchange client script i have selected variable as
Nothing is coming when I selected past date or withing 2 working days. I'm not sure is this active are not Please can you provide the xml of that script and provide the name of that script so after importing i can verify. If I'm missing anything.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
I will suggest to use GlideAjax and schedule for validating business days
if customer in future says to follow schedule to validate business day the script needs to be changed again
did you check the link I shared which has approach using GlideAjax and Schedule?
Variable Date no less than 5 business days
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@Ankur Bawiskar ,
Thank you for your response.
But there is no schedule OOB which says Sunday to Thursday in that case it is very difficult right? Please help me with exact code which as per my requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
if customer is using that schedule then it should be there in the instance
They must be using schedule for their Incident SLAs etc why not use that only?
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
I have reviewed the approach you provided; however, it is still not working as expected. After applying my customizations, I am still facing issues. whatever i select the date every time it is showcasing the alert this not expected. Could you please review and help identify what might be missing?
For your reference, I am sharing the updated implementation below:
Script:
I have added the sys id of the schedule (RX IT Working Hours) not schedule entry (Sunday-Thursday 7:30-6:30) I hope that is correct right?
Thank you
