Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more 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

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

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
Mega 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.