A method stores records for a set of entities that are generated using an input parameter that is not based on a date. A query is received that includes one or more date parameters, the query for aggregating a value. Upon receiving the query, the method performs: selecting a set of records from the stored records that are valid based on comparing first date information determined from the one or more date parameters and second date information from the records; performing an aggregation calculation of the value for the set of records to generate a query result; and returning the query result in response to the query.