Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jack To Find the First Saturday of any month RE: To Find the First Saturday of any month

  • August 12, 2009 at 1:57 am

    #1037878

    wildh (8/12/2009)

    One thing to be mindful with - SET @dt = DATEADD(d,1-DAY(@dt),@dt) is that when it's used with getdate() the result includes the time as well as the date.

    Wildh,

    Good point, I'd overlooked that.

    Nigel

    Nigel
    How to post questions