isoman4not5
MIS
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