I have a query which returns DISTINCT dates in descending order. Here is an example:
10/18/13
10/04/13
09/20/13
09/06/13
08/23/13
In two weeks from now, the results will be:
11/01/13
10/18/13
10/04/13
09/20/13
09/06/13
08/23/13
How do I exclude the most recent date? In the second example, I would not like 11/01/13 to be a part of the results.
Thanks!!