Filter Not Working for Indexed Column on Modified Date

 I have tried for the same scenario.Its working fine for me.You need  data for <= two years.

Please check your modified date column is hold those dates. If possible share the modified date column screen shot.

 

Hi Maha,

 

Thanks for the quick response.

 

Whatever may be the change in logics the data is not retrieving any records.

 

I tried [Today]-365,[Today]-730 whatever is not retrieving the records.  

The logic may be wrong in the filter. Based the screenshot, you are trying to retrive the data before 450 days (modified). check the modified date field having apprx 2 years of data.

 

 

If you are facing any complication in logic. please share the scenario with me... i will share the logic.

Hi Raghavendar,