6 Replies Latest reply on Feb 6, 2016 10:01 AM by kevin antony

    last month year should be minused

    kevin antony

      We have a display date calculated field ,it 's taking period column for the date.


      and the period should be minused in the query if it falls on year end that is december


      Please help me on this ,this the query which I have user for display date :


      if CONTAINS([Time],"Weeks") then




      in this I need to minus the period if it falls on December 31st ,How I need to do,Please update me on this.