8 Replies Latest reply: Aug 22, 2013 9:44 AM by Alan Farrell RSS

    Select Highest Day of Month

      Hello,

       

      I have a collection of records with dates. I want to select the highest day of each month. for example:

       

      Article1 - 01-08-2013

      Article1 - 10-08-2013

      Article2 - 05-08-2013

      Article2 - 14-08-2013

       

      I want to select:

      Article1 - 10-08-2013

      Article2 - 14-08-2013

       

      I want to do this in script. Something like MaxDay(), but MaxDate from the specific month.