flow designer due date

suprajam
Tera Contributor

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 .

1 ACCEPTED SOLUTION

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.

View solution in original post

12 REPLIES 12

Naga Ravindra R
Kilo Sage

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

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

 

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.

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