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?
RakeshRSingh
SSCarpal Tunnel
Points: 4109
More actions
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.
🙂