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 [EMAIL PROTECTED]
