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

    This month vs. previous month

      Hi,

       

      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.