5 Replies Latest reply: Jun 14, 2016 4:32 PM by Sunny Talwar RSS

    Text Object Calculation

    Linda Pembroke

      Hi,

      I want to create a text box that says: Data Processed From 1/1 of the year prior to the selected year through the max report date of the year prior to selected year. Ex. "Data Processed From 1/1/2016 - 5/31/2016" when 2017 is selected.

       

      I have the first part but am having trouble with the second.

       

      =If(Only(Year),'Data Processed From 1/1/' & (Only(Year)-1))

       

      It doesn't have to be all in one formula, but that would be ideal