4 Replies Latest reply: Mar 8, 2013 6:36 AM by Tyler Waterfall RSS

    Last 12 months,last 3months data using Inmonthtodate function

      i have the Fiscal date as the date in my data.So,i want to obtain last 12 months data including current month and i want last 3 months data excluding current data.I have written the following expressions but these are not working..

       

      For last 12 months data :

      if(InMonthToDate([FiscalDate],today(),-11,0),1,0) as  12MTD

       

       

      For the last 3 months data :

       

      If(InMonthToDate([FiscalDate],today(),-3,0),1,0) as  3MTD

       

       

      Can you please help me how to proceed with these above expressions.