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
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.
:rolleyes:
I tried case but in oracle forms6i, case is not supported.