limit data in automated report

[MarkP]

@mikeil

. . . and while they’re doing that, they could easily give you a few more useful dates: first day of previous month, last day of previous month, first day of rolling 3 months, first day of calendar year, last day of calendar year, first day of financial year, last day of financial year etc. etc.

Very true.

Refer them to this thread if they don’t know what to do:

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…