S
S Davis
Hello, I need help with this problem. I have two lists of dates. I am
using a table as a filter for this list. What I want to do is create a
final listing of all dates that are less than the minimum date in the
filter. This is probably easier to demonstrate than to explain:
Data:
1/3/2007
1/2/2007
1/1/2007
12/31/2006
12/30/2006
12/29/2006
Filter(Table)
2010
2009
2008
2007
Essentially, I want to display the MAX value from Data that's year is
less than the minimum value of Filter(Table). The result should be
12/31/2006
Thanks!
using a table as a filter for this list. What I want to do is create a
final listing of all dates that are less than the minimum date in the
filter. This is probably easier to demonstrate than to explain:
Data:
1/3/2007
1/2/2007
1/1/2007
12/31/2006
12/30/2006
12/29/2006
Filter(Table)
2010
2009
2008
2007
Essentially, I want to display the MAX value from Data that's year is
less than the minimum value of Filter(Table). The result should be
12/31/2006
Thanks!