newbie here, I simply need to get an Oracle report, which I have successfully gotten to run weekly using code: CAST("AR Origination Date"."Day Cal Date" AS DATE) BETWEEN (current_date)-1 AND (current_date)-0
I for the life of me cannot, trying several sql code attempts get a monthly report run. I do not need to group, nor count. I just need this report to run monthly. Does anyone have any ideas? I've tried a few things I've found online only to get errors.
Attached is a picture of what I'm dealing with.enter image description here
Sorry, deleted all tries of everything.