Sort Pivot Table for Data Between Two Dates

[Gra06021]

I am working with some poorly designed data... the query return two columns (a start date and an end date). I need to be able to select a date and see which projects were active at that time. Ideally I would like to be able to do this in a pivot table but I am also open to other solutions so long as they are dynamic.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Funding[/TD]
[/TR]
[TR]
[TD]6/25/2012[/TD]
[TD]6/24/2015[/TD]
[TD]$200,000[/TD]
[/TR]
[TR]
[TD]1/1/2010[/TD]
[TD]12/31/2014[/TD]
[TD]$500,000[/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any suggestions on how to get my filters set up on the pivot table in order to accomplish this?

Thanks!

 

[Gra06021]

Does anyone know how to apply a filter for dates in between two points? For example in the above data if I wanted to show what what active in 2013?

Thanks,
Ron

 

[SpillerBD]

Does anyone know how to apply a filter for dates in between two points? For example in the above data if I wanted to show what what active in 2013?

Thanks,
Ron

Maybe criteria of...
End Dates >= Jan 1, 20113 AND Start Dates <= Dec 31, 2013