Thanks Jeffrey, I see and now understand where the close parenthesis was missing. that  makes better sense.

I am calling the stored procedure from a C# Windows Application Menu item. I...

Hi Jeffrey! I have been battling with the

Declare @previous_date  date = iif(day(getdate() > 16, dateadd(day, -1, getdate()), eomonth(getdate(), -1));

Command you suggested. It keeps erring out with...

Great suggestions! Much appreciated.

Thanks Jeffrey, that does  help a lot. I will modify the alias piece, just have not gotten to it  yet. Function before form... Yes sld.ControlPointName would be correct.

I really appreciate...

Jeffrey, here is the complete script. This appears to be working;

Note I added an additional Declare for @prev_date. Then changed  [End of Month] to [Yesterday] in the select statement.

Does that...

Hi Jeffrey,

I think this is what I need to add/change

Declare @last_day datetime = DATEADD(day, -1, convert(date, GETDATE())) 

Is this correct?

Sorry Jeffrey, I was not very clear there.

What I am looking it is for example today is the 22nd and lets say the boss wants to go up to the...

Jeffrey, one last afterthought question;

With regard to the current Month query; What if I wanted to go to @current_date -1?

I tried changing the @last_day to date = day(day(@current_date), -1) .

This...

Jeffrey, thank  you. that is very helpful and explained well.

Arron/Scott, Yours were very helpful and I appreciate all the explanation and recommendations. I learned a lot from this little query!

First off, THANK YOU to all of you.

Jeffrey, one clarification question regarding Month/Day/year. The boss wants that info there. I am not following comment # 7 completely.

Also if I want...

Scott, I think this is the answer. Please review and give me  your opinion.

USE tmdsDatabaseStatistics
--DECLARE @day int
DECLARE @month int
DECLARE @year int
DECLARE @d DATETIME = getdate(), @day TINYINT...

Scott, I modified the query and it looks like this (included to make sure we are both on the same page);

USE tmdsDatabaseStatistics
DECLARE @day int
DECLARE @month int
DECLARE @year...

I will give a try when I get back to my desk.

thanks Scott

How do I pass a variable to the CASE Statement for the First/Middle/End of Month.

doing a

DECLARE
@year int
@month int
@day int
SET @year = 2022
SET @month = 8
SET @day =...

Scott/Aaron, I think  I have nailed the basic. Take a look at this one.

I still have to figure out how to replace the 1, 15, 31 for;

DECLARE @FirstDOM datetime, @NextFirstDOM...