Filter for Yesterday

[MarkP]

If someone else can change the universe, that is the best solution.

I’ve always used relative dates for scheduled reports. By relative dates, I mean the sort of things in this sticky in the universe section:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

If you point your universe people towards that, they may realise that it’s best practice for scheduling reports and implement it for you.