add revenue_on_date method (needs refactoring)