Filter to get employee data till last week

[priya2611]

Hi,

I'm using the below filter in EmpJob Odata to get a snapshot of last week's employee file, it's not a delta but should get details till date 

But is my filter correct to compare endDate with lastWeekEndDate as its  <endDate>9999-12-31T00:00:00.000</endDate> to all employees and doesn't make any sense

Current filter:

$filter=emplStatusNav/externalCode ne 'O' or emplStatusNav/externalCode ne 'R' or emplStatusNav/externalCode ne 'RNS' or emplStatusNav/externalCode ne 'T'
and employmentNav/hiringNotCompleted eq false and endDate lt datetime'${property.lastWeekEndDate}'