Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Finding New Years Eve RE: Finding New Years Eve

  • January 9, 2013 at 9:34 am

    #1575316

    -- In 2008 + you can use a date instead of a datetime with implicit conversion

    DECLARE @Date date = GETDATE()

    SELECT DATEADD(DAY, -DATEPART(dayofyear,@Date),@Date)

    David Bridge
    David Bridge Technology Limited
    www.davidbridgetechnology.com