Returning First Day of Current Year

[luvtitans50]

I have a formula that I have created:

checkdate between '2010-01-01' and (Select checkdate from prcheckheader where checknumber = @checknumber)

I don't want to have to remember to change ('2010-01-01' )
to always be the first of the year? How can I write the date so it always picks up the first day of the current year?

Thanks!

 

[IanWaterman]

SELECT
DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS FirstDayOfYear

Not my code but found here

http://wiki.lessthandot.com/index.php/How_to_find_the_first_and_last_days_in_years,_months_etc

Ian

 

[genomon]

Have a look at DATEPART() and GETDATE() functions. You can extract the year and leave the 01-01 static.

Beir bua agus beannacht!

 

[djj55]

There are several FAQ on dates

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[luvtitans50]

Thanks for all of your help!!!