- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 01:46 AM - edited 02-27-2023 03:23 AM
I want to set due date in flow designer where i just need to minus 14 days from current date and return in due date for flow designer .
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 04:17 AM
var gdtDateTime = new GlideDateTime();
var grSchedule = new GlideRecord('cmn_schedule');
grSchedule.addQuery('sys_id', '377f9850dbe07b803b841ded0b961950');
grSchedule.query();
if (grSchedule.next()) {
var counter = 14;
var grSched = new GlideSchedule(grSchedule.sys_id);
for (i = 0; i < counter;) {
gdtDateTime.addDaysLocalTime(-1);
if (grSched.isInSchedule(gdtDateTime)) {
i++;
}
}
}
var todayDateEsd = gdtDateTime;
var gettingDate = todayDateEsd.getDate();
return gettingDate;
Make sure you create a schedule in 'cmn_schedule' table and have a schedule entries .
Refer to the screenshots.
Please mark as correct/helpful if it helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 02:24 AM
Hi @suprajam
following is the script to do the minus
var grSchedule = new GlideRecord('cmn_schedule');
grSchedule.addQuery('sys_id', '377f9850dbe07b803b841ded0b961950');
grSchedule.query();
if (grSchedule.next()) {
var counter = 5;
var grSched = new GlideSchedule(grSchedule.sys_id);
for (i = 0; i < counter;) {
grStrDateTime.addDaysLocalTime(-1);
if (grSched.isInSchedule(grStrDateTime)) { //pass your date variable in grStrDateTime
i++;
}
}
}
var todayDateEsd = grStrDateTime; //here you will get the value
var gettingDate = todayDateEsd.getDate(); //here only date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 02:31 AM
hwy thank you but what do you mean when you say "pass your date variable in grStrDateTime"
i want to minus 14 business days from current date the ritm was created and return it in due date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 03:15 AM
Hi @suprajam ,
Here you go,
var gdt = new GlideDateTime(fd_data.trigger.request_item.variables.Action_date);
var gdtDateTime = new GlideDateTime(gdt);
var grSchedule = new GlideRecord('cmn_schedule');
grSchedule.addQuery('sys_id', '377f9850dbe07b803b841ded0b961950');
grSchedule.query();
if (grSchedule.next()) {
var counter = 5;
var grSched = new GlideSchedule(grSchedule.sys_id);
for (i = 0; i < counter;) {
grStrDateTime.addDaysLocalTime(-1);
if (grSched.isInSchedule(gdtDateTime)) {
i++;
}
}
}
var todayDateEsd = gdtDateTime;
var gettingDate = todayDateEsd.getDate();
return gettingDate;
Please mark as correct/helpful if it helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-27-2023 03:20 AM
im so sorry, the action date part i dont want starting i have mentioned it wrong my mistake but i just need to minus 14 days from current date and return in due date for flow designer, thank you so much in advance can you please send it now as it is urgent and i have been trying everything and didnt get it