-
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
-
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
-
I tried case but in oracle forms6i, case is not supported.
-
Originally Posted by LKBrwn_DBA
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|