# Calculating a Total Based on Dates

Question asked by ChristopherMoran1701 on May 7, 2013
Latest reply on May 7, 2013 by philmodjunk

### Title

Calculating a Total Based on Dates

### Post

What i want is quite simple really...

I have 5000 Records, all records have a date on them from when they were created, all records have a Subtotal amount, Tax amount, Shipping and Grand total,(even if that amount is \$0)

5/7/2013
\$500 <----Subtotal from line items
\$20  <----Determined in a script by Subtotal amount
\$20 <----- Tax, Calculation of Subtotal x .5
\$540 <----- Grand total, all 3 items added together (duh)

soooooo, lets get to the point, I want to be able to take the date of 1/1/13 to the current date (begining of year, to current date) and have a calculation of the grand total for the entire period of time between those dates, so basicly showing me a grand total of all my grand totals for that amount of time...

I've searched all over, found a few good ideas but nothing really seems to work right