Filter condition

[Rosy14]

How to get list of records where end date is not more than 14 days from current date?

[Anurag Tripathi]

Here is a sample script for change request, you can change the table/field names as needed.

var records = new GlideRecord('change_request');
records.addEncodedQuery('end_dateRELATIVELT@dayofweek@ahead@14^end_date>=javascript:gs.beginningOfToday()');
records.query();
while (records.next()) {
	//records.getValue('number'));
//do whatever
}

[Rosy14]

Hi,

Can you show me the condition in filter of the list.

[Anurag Tripathi]

Something like this, 

You can always modify the filter to get the result you need.

[Anurag Tripathi]

is this thread answered @Rosy14