User bio
404 bio not found
Member since Jan 10

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

Jared has no followers yet.
Jared has not followed anybody yet.
Global Masters badges:
Jared has no Global Masters badges yet.