How can I set automated report view 7, 14, or 30 days prior to a date in the middle of a week or month without manually setting those dates? This/Last Week/Month doesn't take into account current date going back 7 or 30 days. | Community
Skip to main content
Level 2
September 3, 2020
Question

How can I set automated report view 7, 14, or 30 days prior to a date in the middle of a week or month without manually setting those dates? This/Last Week/Month doesn't take into account current date going back 7 or 30 days.

  • September 3, 2020
  • 1 reply
  • 477 views

This week shows activity for the current week while last week is only activity exclusively in the week prior. The same applies to this month meaning this calendar month and last calendar month. I want to send weekly reports including activity from that present date going back 1, 2, or 4 weeks. Is this possible without manually entering the dates for the report and sending out? I prefer setting up repeating deliveries. Right now I have 2 items entered the exact same date and one item shows on my report for last week and the other doesn't!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

imgrund
Adobe Employee
Adobe Employee
September 4, 2020

Hi - I'm not sure what you mean by activity, but you can use the $$TODAY filter for your reports. If this is a task report and you want to know which tasks closed in the last week, you can use the filter Actual Start Date is greater than or equal to $$TODAY-1w. If I ran that Wednesday (Sept 2nd), I'd see tasks closed between August 27th and up today.

Hope that helps.