5 Replies Latest reply: Aug 11, 2014 1:39 AM by Tresesco B RSS

    Issue in YTD exp

      Hi all,

      When I try to give the following expression for the calculation of previous year ytd value, I get the result as 0.

      can you please help me out in finding where the issue is?

      thanks in advance



      [Date] = {">=$(=YearStart(vCalendar)-1)"}*{"<$(=Date(MonthStart(vCalendar)-1,'DD/MM/YYYY'))"},

      vcalendar is nothing but today()-1


      Thanks & Regards,