Skip to main content
Question

Report with Date >= Last 120 Days doesn't filter correctly

  • January 19, 2017
  • 0 replies
  • 26 views

kristin_f3c469
Forum|alt.badge.img
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.