Same week last year

Sbhatia
Sbhatia Member
in Beast Mode

Hi, what is the best way to write a beast mode that returns the same week last year, e.g. 09/09/2024 ⇒ 11/09/2023

Best Answer

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I would try this:

    DATE_SUB(datefield, INTERVAL 52 WEEK)
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ArborRose
    ArborRose Coach

    You need to be careful how you compare week from one year to week from another. Depending upon how the calendar falls, it's apples and oranges.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories