Good Day,
Currently I am experimenting with Sharepoint 2003 and I have a web part in it that uses and excel spredsheet to pull data from a database. One column of this table in the database is a date cloumn. I only want to pull data from the last month from the table and then make a function that will allow it to average totals based on these dates dynamically so it will take only the last 30 days from the date thats on the computer. The only problem is i don't know how to get it to pull only the data from the last 30 days and not ALL the data. If anyone has any knowledge with this and can let me know that would be great.

Thanks,
John Burkholder
Kandersteg, Inc.