Current Balance of my Accounts

[adamlylegallagher]

I'm pretty sure it is something easy like replacing Line 8 with something like this:

WHERE c1.STATUS NOT IN ('V') AND c1.TRANSDATE < '2025-09-01'

But that doesn't work for me and I don't know why?

Thanks!
Adam

[adamlylegallagher]

Oh My God. I pasted it into chatgpt and it instantly told me exactly what I was doing wrong and how to fix it. ChatGPT is the greatest thing on earth.

I had to add both:

AND c1.TRANSDATE < '2025-09-01'

To the first section.

And also:

AND c2.TRANSDATE < '2025-09-01'

To the second section.

How is chatgpt that amazing? My mind is blown every day with it.