Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HardlyWork
  • Content: Threads
  • Order by date
  1. HardlyWork

    Use of cdSpecialDateRange function?

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

    Use of alternate date ranges on records selections

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

    Using a formula (date) to select rows

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

Part and Inventory Search

Back
Top