User bio
404 bio not found
Member since Jan 10, 2023
Posts:
show all 1
Replies:
show all 3
Jared Severson · Jan 10, 2023 go to post

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()))

Jared Severson · Jan 10, 2023 go to post

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

Certifications & Credly badges:
Jared has no Certifications & Credly badges yet.
Followers:
Jared has no followers yet.
Following:
Jared has not followed anybody yet.