Never mind. I figured it out. Thank you!
The problem is in the line above, I believe:
and (YEAR(TX3.date_of_service)= YEAR(GetDate())) and MONTH(TX3.date_of_service)= MONTH(dateadd(mm,-1,GETDATE()))
You're correct! I guess I'm back to square one. The query runs inside of the NetSmart Avatar system and pulls no data for December. hmmm
Log in or create a new account to continue