View Single Post
  #1   Report Post  
jburkholder
 
Posts: n/a
Default Excel through Sharepoint 2003 problem


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.


--
jburkholder
------------------------------------------------------------------------
jburkholder's Profile: http://www.excelforum.com/member.php...o&userid=25934
View this thread: http://www.excelforum.com/showthread...hreadid=393076