[thelist] Calculat on calculation in SQL?
Jay Blanchard
jay.blanchard at niicommunications.com
Fri May 17 11:53:00 CDT 2002
Does anyone know if it is possible to do this?
select cycleNumber,
cycleDate,
cycleDateDue,
DATE_ADD(cycleDateDue, INTERVAL 5 DAY) AS ReminderLetterDate,
DATE_ADD(cycleDateDue, INTERVAL 15 DAY) AS ReminderCallDate1,
DATE_ADD(cycleDateDue, INTERVAL 30 DAY) AS SuspendLetterDate, /*A calculated
date*/
DATE_ADD('SuspendLetterDate', INTERVAL 12 DAY) AS AccountSuspendDate
/*Attempt to calculate against that calculated date*/
from tblBillCycle;
TIA!
Jay
More information about the thelist
mailing list