aggr and Add dates to table without dates

[Ran]

hi,

i have 3 tables:

table 1 : drivers
that include ID and Budget

table 2 : vehicles(each car is rent for 3 Years)

there i have ID,License Plate,StartDate(of the Rent), EndDate(of the rent).

table 3 :calendar

in table 1,  i dont have dates but for each driver the budget amout is monthly and doesnt change.

i did an  intervalmatch between calendar(resident) and table 2 to get the months between startdate and enddate

that gave me new month table  with license and id

i need to do aggr by Qtr to the Budget but it doesnt work/get me duplicates🙄

i really need help

Thanks,

[Ryan_McGregor]

If you have the Start Date / EndDate field, could you add another column to that table for Quarter so that it was usable via the intervalmatch?