1 Reply Latest reply: May 30, 2012 9:00 AM by mrpjspencer RSS

    getting last value within YTD(+60 day) range

      Hi Good morning, I am using the expression:- FirstSortedValue(Meter_Reading,-Meter_Reading_Date) to get the most recent value extract from a QVD I use.

       

      I am now looking to get the furthest single record that falls between 425 and 365 days from most recent value date.

       

      Help much appreciated if you can.

       

      Paul.