10 Replies Latest reply: May 31, 2012 8:09 AM by mrpjspencer RSS

    Returning values within a set range

      Good afternoon, I need to do some averages on some data but I only want to use the most recent date and a date thats as close to as a year ago as possible. i.e.

       

      28.05.2012

      24.02.2012

      10.10.2011

      08.07.2012

      29.05.2012

      26.05.2012

       

       

      Above is a range of dates using the most recent date and a date up to a year ago(as close as possible) ignoring all the data inbetween.

       

      How do I go about this?

       

      Kind regards.

       

      Paul.