How to get cumulative team stats up to a given date
I was wondering if there is a way to query cumulative team stats up to a given date. I can get data for a defined day, week, or season (to current date), but I want the data to be cumulative to that date.
Where this would provide me with the teams total stats up to May 1st, 2012.
I know that I could technically subtract the stats for each day back to the date I need, but this is way too tedious and slow, given the fact that some stats would not be easy to calculate (OPS, WHIP, ERA, etc).
I don't see this as an option in the documentation, but it is a very simple query so I think it should be possible. Any help would be greatly appreciated.