SQLServerCentral / SQL Server 2005 / SQL Server 2005 General Discussion / Last Year to Date report parameter / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:07:59 GMT20RE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspxIf there is a report parameter. The fomular will be=DateAdd("yyyy",-1,DateAdd("d",-1,Today()))Thu, 16 Sep 2010 09:05:53 GMTDung DinhRE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspxMy apologies and thanks for the help. It is for SSRS. The date range should have been described as January 1st of last year (1/1/2009) through yesterdays month/day/lastyear. This would be for a report parameter EndDate.edited for mistakeThu, 16 Sep 2010 05:35:29 GMTgorstlRE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspx[quote][b]WayneS (9/15/2010)[/b][hr]1. Change "Today" to "GetDate()".2. In your example, you want the date range to end on 9/14/2010. I assume this is a typo, and should be 9/14/2009?[/quote]I've got the sneaky feeling that this is going to be for an SSRS report which would explain "Today" I think...Anyway, I agree... the op needs to clarify what the date range should actually be.Wed, 15 Sep 2010 18:20:07 GMTJeff ModenRE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspx[quote][b]Dung Dinh (9/15/2010)[/b][hr]You should use[code="sql"]select dateadd(yy,-1,dateadd(d,-1,getdate()))[/code][/quote]Agreed... now all you need to do is to provide the other needed date. ;-)Wed, 15 Sep 2010 18:17:54 GMTJeff ModenRE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspxYou should use[code="sql"]select dateadd(yy,-1,dateadd(d,-1,getdate()))[/code]Wed, 15 Sep 2010 09:31:04 GMTDung DinhRE: Last Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspx1. Change "Today" to "GetDate()".2. In your example, you want the date range to end on 9/14/2010. I assume this is a typo, and should be 9/14/2009?Wed, 15 Sep 2010 08:48:48 GMTWayneSLast Year to Date report parameterhttp://www.sqlservercentral.com/Forums/Topic986221-149-1.aspxHello,I am trying to build a report that needs to query records between Jan01 of last year through yesterdays date, last year. In other words, for today (9/15/2010) I would need 1/1/2009-9/14/2010. I am using the following for my EndDate=DateAdd("y", -1, (Dateadd("d", -1, Today)))It keeps pulling records from both years.Any help for this Newbie would be appreciated.Wed, 15 Sep 2010 06:49:58 GMTgorstl