Rolling two weeks of data

[tbrock]

Hello, i'm in Intelligence and i'm trying to add an expression to my report to show a rolling two weeks' worth of data.  I'm using Sent For Payment as my date filter.

Any assistance would be greatly appreciated..

[KevinD · Accepted solution]

@tbrock I had to dig around a bit in some old folders, but I found what you need. For a rolling two week period, you will need to open the expression editor to create this filter. 

In the expression editor, you will need to type out the following:

[Sent for Payment Date] between _add_days (current_date, -14) and current_date

Give that a try and see if it works for you. Let me know how it goes. 🙂

[tbrock]

Thanks Kevin!  That worked.  Your assistance is greatly appreciated.