get open bills that are <30, 30-60, 60-90, > 90 delinquent based on 2 dates
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: get open bills that are <30, 30-60, 60-90, > 90 delinquent based on 2 dates

  1. #1
    Join Date
    Nov 2000
    Posts
    198

    get open bills that are <30, 30-60, 60-90, > 90 delinquent based on 2 dates

    I am trying to create 1 query that gives me all open bills that are <30, 30-60, 60-90 > 90 delinquent based on the billed_date. any idea on how to do that?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,476

    Cool

    Use a CASE function to classify the bills, check it out in the fine OracleŽ Database SQL Language Reference.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Posts
    198
    I tried case but in oracle forms6i, case is not supported.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Quote Originally Posted by LKBrwn_DBA View Post
    Use a CASE function to classify the bills, check it out in the fine OracleŽ Database SQL Language Reference.

    You should be able to select from a view within Forms 6i. So you need to get the query working as a view and select from the view.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width