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!