@araza123,
If you can't build the query, then post a database or spreadsheet with data you want to analyze. We don't need anything except the recordID and some start and end dates.
SELECT
c.[Claim Entered Date],
c.[Sale Date KY],
(
SELECT TOP 1
q.Quarters
FROM Quarters q
WHERE q.Days > ([c.Claim Entered Date] - c.[Sale Date KY])
) AS Quarter
FROM GAP_Claims_new c
;
If your Quarters Table had a FromDays and a ToDays, you could use a join rather than the subquery field.
think i was very much overthinking this, i think taking the date diference and simply divding it up 90 should work but i would need to round up.
What would be the best approach to have this all in one field. Right now I have my date difference calc as Date_Difference: GAP_Claims_new.[Claim Entered Date]-[Sale Date KY].
if i wanted to add the then divide by 90 and round up, how would i do that
something like Date_Difference: GAP_Claims_new.[Claim Entered Date]-[Sale Date KY]/(90) with it rounding up