go to post Jared Severson · Jan 10, 2023 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()))
go to post Jared Severson · Jan 10, 2023 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
