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

    AddMonths to fetch current year data only

    Abhijit Arankalle



      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.