Skip to Content
Former Member
Jul 12, 2007 at 04:18 PM

Changing aging buckets in Crystal


Post Author: jshynes

CA Forum: Formula

I need to have a custom aging buckets (ranges) created in Crystal.

I use CRXI, MSSql database. pretty much a new user.

I'm also aware of the functions Aged0to30days, Aged31to60days etc... but I need the ranges to be different. Is there anyway to use a formula to create a custom date range so that it'll be 0-60, 61-90, 91-120, 120-180 and over 180 days? The data is invoice dates and invoice amounts.

If noone has an example, can you point me in the direction or suggest for other resources.