I would like to filter a report that shows me any records that are between 14 days prior to the Due Date and the Due Date. Due Date is a date field in my table.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Sherry

Sherry

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
[Due Date] - Today() < Days(14)

OR

[Due Date] - Today() <= Days(14)


Depending on your boundary conditions.