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,492

    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
    4,166
    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.

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