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


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!


  • Sweep_The_Leg

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

  • MattGo

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