How can we help you today? How can we help you today?

Incorrect formatting with BETWEEN and COALESCE

Here is a snippet where the formatting is not working 100%. The first COALESCE is formatting as I expect and want. But the second COALESCE that is creating the ending parameter for the BETWEEN is not formatting, but being left all on one line. I would also expect that the AND along with the ending parameter of the BETWEEN would be on their own lines.

AND @CurrentDate BETWEEN DATEADD(mm, -3,
COALESCE(AssignmentBaseline10Start,
AssignmentBaseline9Start,
AssignmentBaseline8Start,
AssignmentBaseline7Start,
AssignmentBaseline6Start,
AssignmentBaseline5Start,
AssignmentBaseline4Start,
AssignmentBaseline3Start,
AssignmentBaseline2Start,
AssignmentBaseline1Start,
AssignmentStart)) AND COALESCE(AssignmentBaseline10Finish, AssignmentBaseline9Finish, AssignmentBaseline8Finish, AssignmentBaseline7Finish, AssignmentBaseline6Finish, AssignmentBaseline5Finish, AssignmentBaseline4Finish, AssignmentBaseline3Finish, AssignmentBaseline2Finish, AssignmentBaseline1Finish, AssignmentFinish)

Tim
Denver, CO
tgoldstein
0

Add comment

Please sign in to leave a comment.