For Policies with a valid from date of, say 30 Sep 2026 and a valid to date of 30 Sep 2026, I need to create a dashboard that filters those records that fall between >379 days and < 395 days. Basically it's a year and T-minus 335 (for 1 year and 30 days till expiration, or 1 year and 45 days till expiration, and 60 days till expiration. Please don't ask about the one year... not my call, just my job to make this dashboard.
As SNOW doesn't have the ability of two valid to/valid from dates, I'm just stumped on this one. Also, I don't code. Also, I don't have adm rights. Just a flunky trying to create a dashboard.
Any ideas? Anyone? It is much appreciated for any help I can get.
