troubleshooting Question

Aging Formula in update query

Avatar of jvera524
jvera524 asked on
Oracle Database
6 Comments1 Solution354 ViewsLast Modified:
Hello there is a date and agingcategory column in one table and an aging lookup in another table.  Every month the aging category needs to be updated using last day of the month.  So if I am updating the information on June 1, 2012 it should use May 31, 2012. If May 1 it should use April 30, 2012.  I need it to automatically calculate the difference between the month end date and the date in the particular field of the date column.  After calculating the number of days get the appropriate aging category for the difference.  There are 13 aging categories.

An example below.
Date used to calculate aging:      May 31, 2012                        June 30, 2012
date column                         Aging column(on June 1)           Aging column(July 1)
May 15, 2012                           0-30 Days                                31-60 Days

Please let me know if any more information is needed.

Thank you in advance.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros