(MB.CRTEDT > ‘’ /Last 30 days/)
OR (BU.TEDT > ‘’ /Last 30 days/)
OR (BU.TEDT >= sysdate - 30)
Hello- I don’t use the query builder bc I prefer to write my code using the editor, so I have a question reagarding automated reports and Dates.
the query currently looks like this:
(MB.CRTEDT >= ‘2011-09-18’ OR BU.TEDT>= ‘2011-09-18’)
to automate this I was thinking of doing this:
However if I do that it will not take the “>=” so I will miss one day
Then I was thinking
(MB.CRTEDT >= sysdate - 30)
but again a month can have 31 or 30 days. I want to automate this report bc it’s a timely query to run. Any help would be greatly appreciated. Thanks.