Years in SQL and SSRS
Quite often I want to default to certain first or last days in recent years, I always use this script to remind me; SELECT DATEADD(YEAR, DATEDIFF(YEAR, 0, DATEADD(YEAR, –1, GETDATE())), 0), ‘First Day of Previous Year’ UNION ALL SELECT DATEADD(MILLISECOND, –3, DATEADD(YEAR,DATEDIFF(YEAR, 0, DATEADD(YEAR, –1, GETDATE())) + 1, 0)), ‘Last Day of Previous Year’ UNION…