Same week last year

Sbhatia · 2024-09-16T14:50:53+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

I would try this:

DATE_SUB(datefield, INTERVAL 52 WEEK)

I would try this:

DATE_SUB(datefield, INTERVAL 52 WEEK)

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.