T-SQL: January 1 of Whatever Year We Are "In"
Posted on 2014-08-06
I have a T-SQL query in a SQL Reporting Services report that contains two user-defined parameters: @BEGDATE and @ENDDATE. This beginning and ending date range represents the "check date" range and is chosen by the end user, upon running the report.
I have just been informed that I need to "throw out" @BEGDATE and replace it with January 1 of the year that we are in. Now, at the time of this posting, the year of course is 2014. But, for next year and each succeeding year thereafter, we will be in the year 2015, 2016, etc.
What T-SQL syntax do I use, then, that will pull January 1 of the current year that we are in?