10 Replies Latest reply: Mar 24, 2015 9:05 AM by Daniel Oberbillig RSS

    problem with subtracting days from date column

    kumar avisakula

      Hello Experts,


      I have date column as time full date and it is having dates like daily. In report i want to display dates as subtract 7 days from time full date as mention below.

      I tried with date(interval([Time Full Date] - 7,'D'),'YYYY/MM/DD'), but it is working for only first value and rest of dates are displaying continuosly. Pls help me out on this one.