SDU Tools: Nearest Weekday using SQL Server T-SQL

I spend a lot of time doing data conversion work. It's hard to imagine how much of that relates to working with dates and times. A requirement that I had recently was to find the nearest weekday to a given date i.e. find me the closest Thursday to a supplied date.

The NearestWeekday function in our free SDU Tools for developers and DBAs, does this.

It takes two parameters:

@TargetDate date – the date that we're aiming for
@DayOfWeek int – Sunday = 1, Monday = 2, Tuesday = 3, etc.
(values from 1 to 7)

Find out more

You can see itin action in the main image above, and in the video here. The full current version of the code is also shown below:

You can use our tools as a set or as a great example of how to write functions like these.

Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info:

Latest version of the code

Note: the code might wrap when displayed below.

Leave a Reply

Your email address will not be published. Required fields are marked *