Filtering by year

[Kevin Kersey]

I have a table that has a list of dates in one field (called "Issue Date") and a field called "Year". I would like the Year field to be a Value List and when a year is selected, it will only show the dates for that year. For example, In the Issue Date field will be dates 3/15/06, 6/15/06/, 9/15/06, 12/15/06, 3/15/07, 6/15/07, 9/15/07, and 12/15/07. When I select "2006" from the Year value list, then the only dates shown should be 3/15/06, 6/15/06, 9/15/06 and 12/15/06. If I select 2007 from the value list, then only the '07 Issue dates will be shown.

Could someone point me in the right direction as to how to do this?

TIA

Kevin Kersey

[John Mark Osborne]

The attached example file should show you everything you need to know. All you is a couple of calculations and a special relationship.

YEARFILTER.FP7.zip

[Kevin Kersey]

John,

That worked great. Thank you very much.

Kevin