The aging date could be done in the SELECT, so I think the rest of the function can also. When I have done this kind of thing, I have used...

It would be nicer if it didn't have all the macros in it. Still...:-)

I use the following formula in reports:

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE() -3), 0)

Much appreciated. Monday and the coffee had not hit yet. I remember figuring that out last week and don't know for the life of me why it was so difficult...

Thanks, Alan. This is hospital data and I am bound by HIPAA and PMI to not give account numbers or personal information out. I understand (went to the link in...