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

      str(datepart('month',datetrunc('week',[PERIOD],'Thursday')))+str("/")+str(datepart('day',datetrunc('week',[PERIOD],'Thursday')))+str("/")+str(right(str(datepart('year',datetrunc('year',[PERIOD],'Thursday'))),2))

      end

       

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