How to get YTD data in SQL

Question

where (au.[DateTime]>= DATEADD(WK,-12,GETDATE()) AND au.[DateTime]< GETDATE())    
--gets everyday for the last 12 weeks

How can I modify to get every day for YTD?

http://stackoverflow.com/questions/13437362/how-to-get-first-and-last-date-of-current-year — zedfoxus, Aug 12 '15 at 17:06

Holmes IV · Accepted Answer · 2015-08-12T18:47:25.157

1

where au.[DateTime] between DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)
 AND DATEADD(ms,-2,DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0))

This will get you the first day of the current year. A point i am not sure you need the And au.datetime ... since it is YTD it cannot have tomorrow data yet ? I tried -1 MS but for some reason it doesn't work. possible question.

edited Aug 12 '15 at 18:47

answered Aug 12 '15 at 17:33

Holmes IV

1,673
2
23
47

Yes exactly. From the first of the month to yesterdau – Si8 Aug 12 '15 at 18:17
I am sorry but is there way to get the a year from today... so instead of beginning of the year, it will be 8/12/2014? – Si8 Aug 12 '15 at 18:49
1

select DATEADD(year,-1,getdate()) that will get it – Holmes IV Aug 12 '15 at 18:51

How to get YTD data in SQL

1 Answers1