Question
Report with Date >= Last 120 Days doesn't filter correctly
I have a report based on MDA Data, that uses a Date field.
If I use the criteria Date >= Last 120 Days the date values end at 12/18/2016.
When I change the criteria to Date >= Last 90 Days I get the additional date values of 12/25/2016, 1/1/2017 and 1/8/2017. (The dates are all weekly date stamps on Sundays.)
How can this be?? Getting tired of spending hours debugging something only to realize simple reporting criteria is broken.
If I use the criteria Date >= Last 120 Days the date values end at 12/18/2016.
When I change the criteria to Date >= Last 90 Days I get the additional date values of 12/25/2016, 1/1/2017 and 1/8/2017. (The dates are all weekly date stamps on Sundays.)
How can this be?? Getting tired of spending hours debugging something only to realize simple reporting criteria is broken.