Add days to a date

[samuelscott]

Hello,

I'm working on a script action where I'm trying to add days to the date of creation. Somehow, the syntax I'm using of "addDays();" is not working and when debugging, the logs display "undefined". I'll attach a picture of the debug logs. Could someone please help add days to the date? Thanks!  

iDate(); function iDate(){   var created = new GlideDate(); var dayLimit = new GlideDate();//va a ser igual que el "process on" y "process on" es siempre el dia en el que se abre el task + 15     var task = new GlideRecord('sc_task');   task.addQuery('request_item', current.sys_id);   task.addQuery('state', 1);//(OPEN) es el ultimo task   task.query();     if (task.next()) { //cuando encuentres el primer match, entra a ese registro       created = task.sys_created_on; //task.sys_created_on; //task ya tiene el objeto del registro   if(dayLimit>created.addDaysUTC(15)){//created.addDaysUTC() no esta jalando   task.state = 2;       }     task.update();       }     var str = 'RFS created date: ' + created.toString();   str += ', Sys created (sin string): ' + created;   str += ', Day Limit: ' + dayLimit;       gs.log (str,'RFS query'); }

[samuelscott]

iDate();
function iDate(){


var created = new GlideDate();
var dayLimit = new GlideDate();



var task = new GlideRecord('sc_task');
task.addQuery('request_item', current.sys_id);
task.addQuery('state', 1);
task.query(); 


if (task.next()) { 

created = task.sys_created_on; 
if(dayLimit>created.addDaysUTC(15)){
task.state = 2;

}

task.update();

}


var str = 'RFS created date: ' + created.toString().addDaysUTC(15);
str += ', Sys created (sin string): ' + created.addDaysUTC(15);
str += ', Day Limit: ' + dayLimit;

gs.log (str,'RFS query');
}

[Bob Fulkerson]

Hi Samuel,

I don't think the issue is with the addDays() method.   What is returning undefined is the dayLimit variable and I do not see where you are applying addDays to this GlideDate object (i see it applied to the created GD).   Are you sure you had the dayLimit variable defined when you ran your test?

[samuelscott]

I'm sorry, let me show you an updated code with its debugging logs. When I tried adding days to the other dates besides "Day Limit" they all returned undefined.

iDate();
function iDate(){


var created = new GlideDate();
var dayLimit = new GlideDate();//va a ser igual que el "process on" y "process on" es siempre el dia en el que se abre el task + 15




var task = new GlideRecord('sc_task');
task.addQuery('request_item', current.sys_id);
task.addQuery('state', 1);
task.query(); 


if (task.next()) { 

created = task.sys_created_on;
if(dayLimit>created.addDaysUTC(15)){
task.state = 2;

}

task.update();

}


var str = 'RFS created date: ' + created.toString().addDaysUTC(15) + '\n';
str += 'Sys created (sin string): ' + created.addDaysUTC(15) + '\n';
str += 'Day Limit: ' + dayLimit.addDaysUTC(15) + '\n';
str += 'Task State: ' + task.state; 

gs.log (str,'RFS query');


}

[Bob Fulkerson]

Hi Scott,

Ah ok, thanks.   The issue is that the addDaysUTC method does not have a return value which is what you are trying to include in your log output string.   You would need to use the getValue() method of GlideDate after applying addDays and include this in your log output string like so:

iDate();  

function iDate(){  

var created = new GlideDate();  

var dayLimit = new GlideDate();//va a ser igual que el "process on" y "process on" es siempre el dia en el que se abre el task + 15

created.addDaysUTC(15);

dayLimit.addDaysUTC(15)

var str = 'RFS created date: ' + created.getValue() + '\n';  

str += 'Sys created (sin string): ' + created.getValue() + '\n';  

str += 'Day Limit: ' + dayLimit.getValue() + '\n';      

gs.log (str,'RFS query');  

}