2 Replies Latest reply on Aug 3, 2018 11:21 AM by Ankit Bansal

    YTD FOR STARTING OF CHOSEN YEAR (JAN 1) TO CHOSEN DATE

    Monisha Ramesh

      Hello,

       

      I have a Dynamic Date Parameter where any date can be chosen from years 2016 2017 2018. I want to be able to calc the ytd calculation from the starting date of chosen year to the date chosen.

       

      Ex. If Date Parameter chosen is July 31 2018. I want to calculate YTD from Jan 1 2018 to July 31 2018.

             If Date Parameter chosen is Novemeber 1 2017. I want to calculate YTD from Jan 1 2017 to Nov 2017.

       

      Currently, I am using a DATEDIFF Formula which calculates only for the year chosen year as in the Full year of 2016 or 2017or 2018.