Solved: 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

@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. 🙂

Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

View solution in original post

KevinD

@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. 🙂

Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

tbrock

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