2 Replies Latest reply: May 16, 2013 3:17 AM by Sushil Kumar RSS

    max(month) by year

    Nick Gan

      Hi,

       

      I am trying to do a max month, by year.

      but how can i do that in LOAD?

      It should return only 2011 DEC and 2012 FEB.

       

      sounds simple, but i'm stuck...

       

      2011 MAR

      2011 DEC

      2012 JAN

      2012 FEB

       

       

      Thanks.