error in comparing two dates

yoli1
Tera Contributor

hello all my code doesn't seem to work any help?

var currentTime = new GlideDateTime();
var closedtime = new GlideDateTime(current.close_at);
var result = gs.dateDiff(closedtime, currentTime, true);
if ((current.state == '3' || current.state == '4' || current.state == '7') && result > 120) {
    answer = false;
} else {
    answer = true;
}
7 REPLIES 7

SumanthDosapati
Mega Sage
Mega Sage

Hi @yoli1 

 

In second line check if field name is 'close_at' or 'closed_at'.

Looks like you missed 'd' in spelling.

 

Regards,

Sumanth

hi @SumanthDosapati can this be done by condion builder?

Siddhesh Gawade
Mega Sage
Mega Sage

Hello @yoli1 ,

 

Try below script and let me know.

 

var currentDateTime = new GlideDate();
var closedDatetime = new GlideDateTime(current.close_at);
var closedDate= closedDatetime.getDate();
var result = gs.dateDiff(closedDate, currentDateTime, true);
if ((current.state == '3' || current.state == '4' || current.state == '7') && result > 120) {
    answer = false;
} else {
    answer = true;
}

 

Kindly mark the answer ✔️ Correct or Helpful ✔️ If it addresses your concern.


Regards,

Siddhesh

Chaitanya naram
Kilo Sage

Hi @yoli1 


Please try below script.

 

 

var currentTime = new GlideDateTime();
var closedtime = new GlideDateTime(current.closed_at.getDisplayValue());
var result = gs.dateDiff(closedtime, currentTime, true);
if ((current.state == '3' || current.state == '4' || current.state == '7') && result > 120) {
    answer = false;
} else {
    answer = true;
}

 

 

 

Thanks & Regards | Chiranjeevi Chaitanya Naram
Kindly mark the answer Correct and Helpful if it helps to resolve your issue.