var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to return 2 most recent dates
Hello I have a question I hope someone can help me with.
The Data Looks like the following:
Shares Amount Date RIC
What I would like is for Each RIC to have a query that brings back the most recent dates in separate columns. For instance the output would be
RIC Most Recent 2nd Most Recent
SRCE.OQ 10/22/2008 7/21/2008
MMM.n 06/30/2008 01/31/2008
COMS.OQ 09/26/200 07/18/2008
I was think DMAX may work but I can not get it to work. If anyone has any ideas I would be very appreciative. Thanks in advance.
What if the top two dates are the same? What would you want back?
It won't be possible because the Date and RIC are both primary keys so I can't have redundant dates given a RIC. So the dates should brought back should be different.
I think I get it now. You want it grouped by RIC first, THEN pull back the first and second most recent.
That is exactly what I want it to do. Thanks.