1 Reply Latest reply on Jul 3, 2013 9:11 AM by Dana Withers

    How do I subtract one day from a relative day equation?

    Jerry Ward

      Our data brings in all of the data besides TODAYS data.  I am using a relative date equation to build MTD, YTD, WTD in the reports.  But the comparison is not correct from last year because TODAYS data for this year has not arrived yet.  I have tried subtracting a day from TODAY in the equation but it doesn't seem to recognize it in the equation.


      Here is the equation I am using for Relative Date:


      dateadd('year',datediff('year',[StatDate], TODAY()),[StatDate])


      I would like it to be from YESTERDAY no TODAY() in the equation so the Y to Y comparison will be correct per our data.


      Any ideas how to subtract 1 day from TODAY in this equation?