Error in Reports

[Kaushal_Didwan1]

I am generating a report which selects all the rows which has a date value of greater than 25 so in my filter clause then condition which I mentioning is today()-[Date] > 25… is it right or wrong??

[Aleksi]

You are probably looking for DAY([Date])>25.

[Kaushal_Didwan1]

This will return me all was value of dates which are dates above 25 but not the difference between today and DateField which exceeds 25 days.

I am trying to filter all of my customer orders which have not been delivered within 25 days

[Phil]

If you want to select records where the “Date” is 25 days ago or more you should write:

([Date] + 25 ) <= TODAY()

[Aleksi]

Writing the formula like [Date]<=TODAY()-25 your app would need to calculate the subtraction only once.