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?

       

      Thanks,

       

      Jerry