Thanks for the feedback, Simon.

Finding this a bit amusing,  "The criteria is that if the 1st of the Month is a Monday then use that Date otherwise use the last Monday of the...

How nice it is to see this again - a bunch of folks working the hell out of a problem to come up with their solutions, each one faster...

How nice it is to see this again - a bunch of folks working the hell out of a problem to come up with their solutions, each one...

Talking with the current company lawyers might be the best thing to do.  Of course you'd have to get it in writing but you never know... they might just say...

This should do, short and simple 😉 😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
DECLARE @MYDATE DATE = '20190101';
;WITH TDATES AS 
(
SELECT DATEFROMPARTS(
       DATEPART(YEAR,@MYDATE)
...

Also, I missed the final post by Des Norton.  Tested that in the same manner as I did previously and his code also also seems to work correctly.

Heh... that's what you get for posting PowerShell on an SQL Forum. 😀 😀 😀

The problem is very likely the use of both carriage return and line feed (newline) from...

Provided that they're not too long, you could use "Extended Properties" (in SQL Server, anyway) to keep track of things.  Another method would be to actually store certain documentation in...

Whew!  Still checking but the same August 1954 output from the function I built lists things as the OP requested.

So does September 1954...

Ah... crud.  Sorry... I have to take back what I said about Chris' code.  I noticed that he was using a DATEADD of 27 days in the final result and...

Shifting gears, I expanded the test dates on Chris' good code and it seems to handle the "leading" edge cases in the places I looked.  He also did it in...

• This reply was modified 6 years, 11 months ago by Jeff Moden. Reason: Had to retract what I said because I did find some errors

p.s.

Here's what the output looks like.  The highlighted row is the "leading" edge case that I spoke of in my previous post.  As you can see below, the function I...

Hi I have a requirement to calculate the start and end of the working Month, The criteria is that if the 1st of the Month is a Monday then...

Does that table contain login names and passwords?