Good morning community! I need a formula that dynamically changes a date range to “Last week’s date range. I want the widget that I have to always be displaying data based on last week.
Any help is appreciated…
Answer
Dates (Last Week)
Best answer by lauraj46
Hi
On the filter you can specify @WeekStart - 7 and @WeekEnd - 7. Choose the standard option from the dropdown, and then click into the field to type the -7.
Hope this helps!
Laura
+8Hi
On the filter you can specify @WeekStart - 7 and @WeekEnd - 7. Choose the standard option from the dropdown, and then click into the field to type the -7.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.