error in comparing two dates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2024 04:28 AM
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;
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2024 04:37 AM - edited 01-02-2024 04:38 AM
Hi @yoli1
In second line check if field name is 'close_at' or 'closed_at'.
Looks like you missed 'd' in spelling.
Regards,
Sumanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2024 05:57 AM
hi @SumanthDosapati can this be done by condion builder?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2024 04:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2024 04:59 AM - edited 01-02-2024 05:20 AM
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;
}
Kindly mark the answer Correct and Helpful if it helps to resolve your issue.