
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 14, 2023 04:25 PM
I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 14, 2023 06:02 PM
For example, this formula could display "previous week" if the date was previous week.
IF(
{Date},
IF(
DATETIME_FORMAT(DATEADD(NOW(),-1,"weeks"),"w")=DATETIME_FORMAT({Date},"w"),
"previous week"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 14, 2023 06:02 PM
For example, this formula could display "previous week" if the date was previous week.
IF(
{Date},
IF(
DATETIME_FORMAT(DATEADD(NOW(),-1,"weeks"),"w")=DATETIME_FORMAT({Date},"w"),
"previous week"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 15, 2023 08:56 AM
Thank you so much! I was absolutely overthinking it and this is much more straight forward.
