5 Replies Latest reply: Oct 8, 2018 12:13 AM by Abhijit Arankalle RSS

    AddMonths to fetch current year data only

    Abhijit Arankalle

      Hi

       

      I am using below functions to fetch current year and current month less one month but I am getting data for all years.

       

      Although month is as expected by me.

       

      let vCurrentMonthYear  = '=year(addmonths(max(BillDate),1))';

      let vPriorMonth  = '=month(addmonths(max(BillDate),-1))';

       

      Please help.

       

      Thanks and Regards,

       

      Abhijit Arankalle.