********************************************************************* * CZ801.T02 DB-EZTest Tech Note March 1998 * * * * KEYWORDS: DB-EZTest YYMM=ONLY * * * * YYMM=ONLY may be specified on the #SDETAB entry for a date to * * instruct the EZTest software to age the YYMM portion * * of a date leaving the days alone. * * * * This is fine if the day is always 01 or less than 29, however * * inconsistencies will arise with days > 28 as the * * software will not allow an invalid date. If the * * resultant days is higher than the max for the month * * then EZTest will set it to the last day of the month. * * If the record is then modified the record is stored * * back on the database with the modified days. * * * * Eg INVOICE-DATE=19980131 and we age by 2 Years 1 month then * * INVOICE-DATE=20000231 is invalid so is adjusted to * * INVOICE-DATE=20000229 * * * * If the record is modified we decrement by 2 Years 1 Month and * * INVOICE-DATE=19980129 is the value stored back on the * * database. * * * * This is a feature of YYMM=ONLY that cannot be prevented as the * * software cannot keep a history of every data occurrence * * aged in case it is modified at some later stage. YYMM=ONLY * * should therefore be used with caution and only when it is * * required and the anomoly descibed above will not occur or * * will not matter to the application. * * * *********************************************************************