4 Replies Latest reply: Jan 31, 2014 10:31 AM by Erik Furlanis RSS

    Fetching rolling N months of data - how to tackle new year

      Dear all,

       

      I have a problem with fetching data of some rolling months.

      As soon as the new year started, the formula I wrote is not returning any data (understandably)

       

      RESIDENT Stock
      WHERE Month(DateInterpret)>=(Month(today())-6) AND Month(DateInterpret)<=(Month(today())-1)
      

       

      What is the best common practice in QV to load data for N rolling months?

       

      thank you so much!