Search results for query: *

Thanks for the reply, this is how I got it to work: {DISBURSEMENTS.ACTUAL_DISB_DATE} in cdSpecialDateRange (currentdate - {?days-off}, "LastFullMonth"). I had to use the currentdate function and adjust it by "days-off" to get to the date I wanted since I can't use the date that is in the...

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.

Thanks Turkbear, you get a red star for your response. Linking the system_dates table to the data_table with a > & < links did the trick.

Thanks for replying. I guess a full explanation of the problem is in order. I need to run reports without parameters and yet, it has to extract data for the previous month or previous quarter, etc. My previous example was just to show what didn't work, the actual dates are more fluid in that...

Hi paulmarr, thanks for your reply. My record selection works jst fine when I select using: {DISBURSEMENTS.ACTUAL_DISB_DATE} in lastfullmonth but when I try to select based on: {DISBURSEMENTS.ACTUAL_DISB_DATE} < {SYSTEM_DATES.PREVIOUS_EOM} and {DISBURSEMENTS.ACTUAL_DISB_DATE} >...

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...