Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula to filter dates to only show last week

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
981 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

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

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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"
  )
)

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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"
  )
)

 

Thank you so much! I was absolutely overthinking it and this is much more straight forward.