How to show report data for 3 weeks back

Robert Haugland · ‎08-05-2020

Hi,

I would like to build a report of incidents created within the last three weeks. How can I do this in the criteria>

George P · ‎08-05-2020

If you are truly look for weeks based on Monday - Sunday regardless of which day you run the report, then I don't think you can do that.

For example, taking the current date (8/5/2020) you want to run a report for created past 3 weeks meaning 7/13/2020 - 8/2/2020, it will not do that.

If that is what you want, submit an Idea to the Idea portal requesting to add "weeks" to the relative filter option. I would give that an up-vote.

Robert Haugland · ‎08-05-2020

Thank you!

Robert Haugland · ‎08-05-2020

I created an idea to add "weeks" to the relative filter option.

Onkar Pandav · ‎08-05-2020

Ah, yes Mr. George. No need to give second condition.

Thanks.

Robert Haugland · ‎08-05-2020

There is no "Weeks" option in the Conditions when using "Relative" and there is no 3 weeks option when using Between. See attachments

Onkar Pandav · ‎08-05-2020

I've edited the answer.

Please check