Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ashka Modi When will the next 13th fall on a Friday? RE: When will the next 13th fall on a Friday?

  • September 10, 2009 at 12:12 am

    #1051580

    If the current date is equal to 13 then your query will give that as Friday.

    IF (DATEPART(dd, @currDate) 13)

    what about adding one more condition with above one

    OR (DATEPART(dw, @currDate) 1)

    then I think your query is perfect.

    🙂