[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