I did, I created a table with the clustered index like date, ID..

i didnt work either...

do you think cause i move the actual data to the partition scheme...

I did a basic one like:

select * from [table_name] where date > '2009-03-01 00:00:00.000'

i tired on my production DB where the table is not partitioned yet and I tried...