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 to post comments
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
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()))
Never mind. I figured it out. Thank you!