Not Gettting data as per last_modified_on condition in period Delta SF query

[tapaswini143]

Hi Team,

I am working on a scenario , where i need to fetch data from compound employee api for both current and 3future dated records.

In the below screenshot i have given the query,

last_run- last rundate time i am saving in variable

fromdate- today date

to date - today+14 days

output:

i am getting future records even if i am giving condtion lastmodified > last rundate and fromdate and todate.

please guide me where i am going wrong, earlier everything was fine.

Regards,

Tapaswini