********************************************************************* * CE801.T15 DB-EZTest Tech Note October 1998 * * * * KEYWORDS: DB-EZTest BIZDAY * * * ********************************************************************* * * * This Tech Note describes how EZ-Test2000 aging takes place * * when the parameter BIZDAY=YES is specified for a date field. * * * ********************************************************************* * * * Regular default aging (when BIZDAY=NO is specified or allowed * * to default) works by calculating the number of days between * * the rundate and basedate and then adding that number of days * * to each date. When BIZDAY=YES is specified, the number of * * days to age by is worked out differently. Unless this is * * properly understood, apparently confusing results can be seen. * * * * The underlying principle is that by specifying BIZDAY=YES * * you are saying that you want the amount of aging to be by the * * number of business days between the rundate and basedate. This * * is not the same as aging normally and then subsequently * * adjusting to ensure that the resultant date falls on a * * business day. * * * * Business day aging is done this way to ensure that dates that * * are a certain number of business days apart will keep that * * relationship after aging. The process also works both ways; * * ie forward aging on a read and reverse aging for a modify will * * produce consistant results. This would not be the case if the * * process was one of simple moving the date forward to the next * * business day. * * * * An effect of this that should be appreciated is that a * * BIZDAY=YES date wil not necessarily age to the same date as a * * BIZDAY=NO date. * * * * One other point to consider is that the basedate and rundate * * should both be business dates themselves. * * * * * * An example. * * Basedate is 7th April 1998 * * Rundate is 14th April 1998 * * * * Default aging is by 7 days. * * Business days aging is by 3 working days as the 10th and 13th * * are holidays and there is one weekend in between. * * * * Date to be aged is 1st April 1998. * * With BIZDAY=NO, it is aged to 8th April 1998. * * With BIZDAY=YES, it is aged to 6th April 1998. * * * * In reality of course, aging will be by a much larger amount * * but this example serves to illustrate the principle. * * * *********************************************************************