Is it possible to derive a recurring date based upon a single date?
Is it possible to derive a recurring date based upon a single date?
(OP)
I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be begin to show 3-11-16. Is that possible? Thanks
This is the best I've had so far but i get an error stating: " ) expected, identifier (_date) found "
SELECT
enrollment_date + (90*ceil((sysdate - enrollment_date)/90)) next_assess, c_id
FROM
cust_summary
WHERE
c_id = ?c_id
This is the best I've had so far but i get an error stating: " ) expected, identifier (_date) found "
SELECT
enrollment_date + (90*ceil((sysdate - enrollment_date)/90)) next_assess, c_id
FROM
cust_summary
WHERE
c_id = ?c_id
Talk To Other Members