Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: HalfDomeClmbr
- Order by date
-
Finding the date for the next 4 Thursdays
Thanks nikhilparchure, I created it a little differently and needed to output the four Thursdays in a month/day format. This is mainly what I've come up with. I had to write the IF (@PubDay <= 5) formula to be sure it selected the next Thurdays and not the closest Thursday. PRINT "CREATE...- HalfDomeClmbr
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Finding the date for the next 4 Thursdays
I am trying to figure out how to make a stored procedure that will output the date of the next four Thursdays. If it is any day of the week I need to find the first Thursday then the next three consecutive Thursdays. I'm thinking that after finding the first Thursday I could do something like...- HalfDomeClmbr
- Thread
- Replies: 3
- Forum: Sybase: Adaptive (SQL) Server
