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: