How to filter out change request whose planned end date is exact 5 days ago

[Anamika Thakur]

Hi,

I want to write filter condition to display the change request only whose planned end date was exact 5 days ago. It should not show the change request who planned end date is more that 5 days ago.

How can I achieve this one.

Any help would be appreciated. Thanks in Advance.

[Devender Kumar]

Hi @Anamika Thakur ,

Please refer the below link.

https://www.servicenow.com/community/developer-forum/how-to-retrieve-data-from-two-and-three-days-ag... 

If my answer resolves your issue then don't forget to mark it as correct/helpful.

Regards,

Devender

[Manmohan K · Accepted solution]

Hi @Anamika Thakur ,

You can use below code to get the change request whose planned end date was exact 5 days ago

var chgGr = new GlideRecord("change_request");
chgGr.addEncodedQuery('end_dateRELATIVEGT@dayofweek@ago@5^end_dateRELATIVELT@dayofweek@ago@4'); 
chgGr.query();
while (chgGr.next()) {
    gs.print(chgGr.number);
}