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 11, 2009 at 1:29 am

    #1037269

    Why not try this -

    SELECT @MONTHSTDATE = DATEADD(MONTH,DATEDIFF(MONTH,0,@STARTDATE),0)

    instead of a long winded convert.