CODEWITHSUNDEEP
oracle-databasesqlcode
Ogdog13
Ogdog13

Reputation: 1

Need to run Monthly Reports in Oracle via SQL Code

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.

Upvotes: 0

Views: 71

Answers (0)

Related Questions