The CreatorCon Call for Content is officially open! Get started here.

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.