Sample Code: ReportRow = 921 issue with coalesce(dateadd(dd, -1, x.ExitDate), rpt.ReportEnd)

[nataliesus]

Hi @rj-delacruz ,

I think bed nights after the ReportEnd should be ignored, as they are in the rest of the report.

Additionally, I see that the Spec also excludes bed nights within the ExitDate .. ReportEnd window when ExitDate <= ReportEnd.

Please rework coalesce(dateadd(dd, -1, x.ExitDate), rpt.ReportEnd) for ReportRow = 921.

This update requires Sample Outputs to be re-generated.

Thank you!
Natalie

P.S. we don't have such issue in i.e. steps 6.13.1, 6.13.2, 6.13.3 because hhid.MoveInDate and hhid.ExitDate are already adjusted to not be after rpt.ReportEnd