4 Replies Latest reply: Nov 16, 2014 11:38 PM by Sergey Makushinsky RSS

    compare QVD and get Previous 12 months of data from Current

      Hi Friends Stuck with Date Functions,I Have a Shipping Period Field with all Dates the Format is

      0201406,

      0201405,

      2014050

      2014060

      1)How to get into YYYYMM like 201406

      2)We will store data in separate QVD for each year based on business requirement

      2012.qvd

      2013.qvd

      2014.qvd

      How to get past 12 months of data from current date,my problem is if i have all data in one qvd i have written as follow

      vCurrent=MonthEnd(MONTHSTART(TODAY())-1)

      vPrevious=AddMonths(MONTHSTART(Today()),-13)

      Where [Shipping Period]>=$(vPrevious) and [Shipping Period]<=$(vCurrent)

      How to check Different QVD and Get data from current date.

      Suppose need to see date of Today() to previous 12 months of Date

      Nov-2014 to Nov-2013 here need to compare 2 Qvds