Hi,
I have data in a table as follows:
Key date
101 4/25/2006
101 4/26/2006
101 4/27/2006
101 4/28/2006
101 5/25/2006
101 5/26/2006
101 5/30/2006
I need the max of date for each month. So my output expected is:
101 4/28/2006
101 5/30/2006
How can I get this? Please help