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.