"I need it to filter on the latest version of each of the 3 documents the person has to sign."

but there's no MAX(Date) anywhere... how are you returning the latest...

the usual way of dealing with a series of IIF statements is nesting them... Here's the barebones structure (which you've sorted out)

=IIF(<test>,<true part>,<false part>)

In your case, I think you...

You don't really have a new column for each day of the month, do you? If you do, that's the source of your problem.

A little normalization is a beautiful...

SSRS and Access reports are alike in that respect - they have their own sorting and grouping, so they'll override the sorting in the dataset. If you want something sorted...

Sounds like a homework assignment. what did you try?

Also, if you post your question like this, you're more likely to get answers...

Nice runnable code to recreate your problem....

CREATE TABLE...

you would need to join to a table of hours and outer join the two...

SELECT Hrs.[TheHour]

,Movie.[StartTime]

FROM Hrs LEFT JOIN Movie...

After looking at this and playing with it for a little while, I stand by my original conclusion - you need the UNsummarized data from somewhere. If you can talk...

do you have the unpivoted data somewhere?

Maybe this article?

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

This is Lynn Pettis' calculation[/url] for first day of the next month...

select dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) -- Beginning of next month

last day of the month is the...

normal way to post is like this...

SELECT '2016-01-31' AS plant_date

, 4 AS History_Ind

, 3143 AS Prop_Code

, '2016-01-19' AS Void_Start_Date

, '2016-03-14' AS Let_Date

, 'Void' AS Void_Status

UNION ALL

SELECT '2016-02-29',4,3143,'2016-01-19','2016-03-14','CFWD'

UNION ALL

SELECT '2016-03-31',4,3143,'2016-01-19','2016-03-14','CFWD'

UNION...

This

cast( cast(year(plant_date) as nvarchar(50))+'-'+cast(month(plant_date) as nvarchar(50))+'-1' as datetime) as plant_date

is a calculated column in your Calendar table.

Sounds like you might want to look up Calendar tables. Here's a good...

Why not just use a Calendar table... you can use a table-valued function to generate a list of dates on the fly. Then it's just a pure count.

A few questions...

1. what's your date format? is that MM-DD-YYYY or DD-MM-YYYY?

2. please explain in English how to get your expected answer. (what does your data mean?)

Another thing... if you...

post what you tried. Part of learning SQL is trying something, and failing, learning from your mistake, and trying again.