Filter data by latest date of data

Hi folks,

a couple of months ago i posted a question where i asked how to sum values according to another column's values, the info i posted was about how many distance a determined vehicle traveled vs how many fuel it consumed, that question was solved, but now in my job i was asked a more specific task, which is like this:

Let's say A car loaded fuel 3 times during month, for example dec. 3, dec. 9, and today (dec. 19) it loaded 20 liters every time it did, and also it's distance was stored in a separated table, so, what i have to do is sum up to the latest date of fuel load of a determined car, the main issue i'm experiencing since the distance a vehicle traveled is in a separated table from the fuel consumption, is that the kms are readed up to the last day of month instead of last date of fuel load, i'll put a graphic example so you can see what i mean:

KMS TABLE

FUEL CONSUMPTION TABLE

COMBINED RESULT

DESIRED RESULT

what i forgot to mention that is important, is that i had to put 2 separate date filters, with only 1, since there are 2 different dates in different tables, the date is sorted by the table it belongs to, for example if i use the date of fuel consuption it only sorts the fuel consumptions and messing up the distances of travels, also, i would like to point out that the traveled distance table will always have more rows since it picks up info every day unlike fuel consumption

Any doubts about this question i'll answer it ASAP,  thanks in advance for any help you could provide me