My first time at trying to use one of the Custom Functions, can someone tell what is wrong with the use of the function below, I've tried several versions of the code below. This last version gives me an error poiting to the SYSTEM_DATES.PROCESS_DATE saying: "a date is expected here" when it is...
Has anyone tried to select records based on a default date- range, unless an optional date-range exists on the same DATES table? CR9, Oracle 10g.
Any hints will be greatly appreciated.
When I use the CR9 Function "in lastfullmonth" to select my rows of data, I get a 13 page report in about 2 minutes (6+ million row search), when I change the Function to a Furmula which also points to last-month (I have verified this), the search turns into a table scan that runs for hours. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.