I have a report with two date parameters, one set to =YESTERDAY() and one set to =NOW(). This worked fine until today (may 1), when I open the report now, the first parameter which should be set to April 30 is set to May 31, 2012 while the 2nd is set to Mat 1, 2012 (as it should be)
Why does the YESTERDAY() function give me a date in the future (the last day of this month)?
I'm guessing it just tries to go back one day in the month, and then loops back to the end of the month on the 1st but could be wrong. Is there another formula I should be using to do this?
Also, when I developed the report in the report designer the parameter was presented with the calendar to select the date but the time was also displayed so that I could set the exact time I wanted to use for my query. When deployed to the bi server, it just displays a date.