0 Replies Latest reply: Oct 28, 2011 9:25 AM by Ronald Wolfers RSS

    calculation of Moving Annual Total for different periods of time



      Just started with qv. Does anybody know how I can calculate an moving annual total for different periodes like:

      - a day,

      - a week,

      - a month?


      My problem is that some years have 365 and some other years 366 days and some years has 53 weeks and some week 52.


      For example day = 22 November 2011, then I need the range of 23 November 2010 till 22 November 2011. How can I calculated this in a script?


      Thanks for your help,