Is there a good solution to reference "date closest to"?

MattGo
MattGo 🟑

I am trying to reference snapshot data from ~8 weeks ago (or ~60 days, or 2 months, any of these would work), and we only snapshot this particular dataset once a week. So I am needing a formula in MySQL or Beast Mode that references the snapshot date closest to 8 weeks ago so I can pull in a field and compare to what the value for that field is today. Any suggestions? Thanks!

Comments

  • Do you snapshot it on the same schedule, i.e. "every sunday night" kind of set up?

  • MattGo
    MattGo 🟑

    So we snapshot it daily for a week, then purge everything but Mondays.