Compare Date date/time fields with same sys_id

[Community Alums]

Hey Everyone, 

I'm super new with the date/time fields in SNOW. Basically I want to compare two date/time field values that have the same sys_id for a task. 

Below is my code for right now. 

var incTask = new GlideRecord("task_sla");
incTask.addQuery("task", "task.sys_id");// task.sys_id
incTask.addQuery("has_breached", true);
incTask.query();

incTask.query();

while(incTask.next()){




gs.info("This is the incident number: " + incTask.task.getDisplayValue());
gs.info("This is the breach times: " + incTask.planned_end_time.getDisplayValue());//breach time column


}

What is happening, I'm getting two values for the same task.sys_id for the breach time column. What I want to do is compare those times and choose the earliest/soonest time to breach. This is where I get a little stuff. Does anyone have any suggestions? 

This is my log output: 

[Sainath N]

@Community Alums : If there are chances of more records, it's best to do it at the query level, like I did in the code, or else you may end up storing all the values in a list, sorting them, and finally returning the first element (the least sorted) from the list.

If this is just for testing purposes, you can use the "GlideDateTime" API and its functions like "before" and "after" methods to check which is the earliest among the two.

https://developer.servicenow.com/dev.do#!/reference/api/tokyo/server/c_APIRef

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Community Alums]

Oh, I think I understand what you mean now.  The method orderBy is giving you the earliest/soonest time by default, which is the reason why it returned only one record. Correct?

I get it now. Super helpful.  See, my technical lead was saying I needed to compare values and that is why I didn't get it. 

[Sainath N]

That’s correct and with this approach it makes your life easy as system does the sorting and returns only the earliest date.

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Community Alums]

Thank you so much!!!!!!!!