3 Replies Latest reply on Apr 8, 2013 6:35 AM by Jonathan Drummey

    Question about "Year to Date (YTD) from Previous Year" in TCRL

    Tony Russo

      I was wondering if there is a way to use the following calculation in the TCRL (thanks Jonathan D. for sharing, found here), but with an altered fiscal year start?

       

      Thanks, Tony

       

      //YTD for previous year

      //replace [Date] with your desired date, returns True if the date is in the YTD from the previous year

      //presumes that there is no data that is future dated

       

      YEAR([Date]) == YEAR(TODAY())-1 AND (MONTH([Date]) < MONTH(TODAY()) OR (MONTH([Date]) == MONTH(TODAY()) AND DAY([Date]) <= DAY(TODAY())))