Then include the revenue date in the revenue table and combine the two revenue tables by concatenating. You may need to add a source code if you need to select data from only one of the revenue tables.
Remove the date fields other than date from the revenue table. Your revenue table is linked on date and will get the derived date fields by association.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein