Thanks Jack!
It worked great! I was able to go back 31days as that is how much summary
log that I keep.  Normally, I have a script which runs in my morning
process that sends a daily summary of GB's backed-up to a log, which I
eventually use for historical reporting.  Because of a problem in another
system this script did not run for several weeks.  I was trying to go back
and pick up the summary's for each of the days I missed.  I did try;
where DAY(end_time) = DAY(CURRENT DATE) -12 -
and MONTH(end_time)=MONTH(CURRENT DATE) -1
and YEAR(end_time)=YEAR(CURRENT DATE)

where I would just subtract the numbers of days back from today, but I
could not get it to work.  At least this way I will have February's total
data,
even if I am missing some of the daily and weekly numbers.
Thanks again,
Shannon Bach
Madison Gas & Electric Co.
Operations Analyst - Data Center Services
e-mail sbach AT mge DOT com