2 Replies Latest reply: Aug 9, 2012 8:39 AM by Felim Shanaghy RSS

    This month vs. previous month



      I am trying to compare a QVD from this month with previous month.  Each month I create a QVD with the month in the title. Please see below:


      Let vtoday = Date(today(1),('MMM YYYY'));

      Store PIF_History into Y:\PL Operations\Leaders\Analyst\SSharma\PIF_History\PIF_History_$(vtoday).qvd(qvd);


      I need to set up another variable which will bring in previous month. For example, in July I need to compare results with June.


      Please let me know if you can help or if you need further explanation.


      Thank you.