Month-to-date through today-2

Is there a way to craft a formula that will provide the month start date through

today-2?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Is this what you're after? It will give you the metric for month to date (up until two days ago):

    if (date > start_of_month(today()) and date <= add_days (today(), -2 )) then [insert column here] else null 

    Like
  • Austin Banta 

    actually, this worked: if ( dt >= start_of_month ( today ( ) ) and dt <= add_days ( today ( ) , -2 ) ) then [column] else null .   thanks so much!

    Like 1
  • how would I get the same thing, but for last year? for example for today, 3/24/2020, i need to know how to define the date range of 3/1/2019 - 3/22/2019

    Like
Like Follow
  • Status Answered
  • 2 wk agoLast active
  • 3Replies
  • 17Views
  • 2 Following