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

Reply
Yellow Belt

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!

Major Blue Belt

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

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

Yellow Belt

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

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

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!