@scdecade, yes, the statement does access the ctes. I've edited my original post to include the entire query. Sorry, I should've done this at first.

@scdecade, sorry for the difficulty. Here is the part of the query that is references the cte, which happens to be another cte:

,VESValidEnrollList AS(
 ...

@scdecade, when I try the above that you provided, I'm still getting the same errors. Any other suggestions, please?

@scdecade, thanks for your input. When I try GROUP BY 1,2,3,4,5 , it still returns the "Each GROUP BY expression must contain at least one column that is...

Thanks for your input, ZZartin!

Thank you, drew.allen! That worked perfectly. I added in a Min, at the beginning, as I need to take the earliest date, and fiddled with the placement of the parentheses...

Thank you, Phil Parkin!

Thank you, Phil. You're brilliant!

Thanks, Phil! I agree that this, is indeed, a monstrosity. I feel like I've had to bend my brain to make sense of it. So a question about your response....

Wow...thank you, everyone for all of your valuable feedback! It's very much appreciated! I meant to apologize for the rather lengthy query, but I was desperate to get some insight....

I believe you could also use COALESCE:

SELECT (LEFT(COALESCE( middlename, ”) , 1) )

Thanks, Jeff. I'll keep this valuable feedback in mind. Meanwhile, I think I've found the issue causing the null dates...it has to do with the date fields not being checked...

Hi @PhilParkin,

Thanks for your comment. Please take a look at my edits.

@kn_murthy, I...