Hello,

Pls tell me what is wrong with my statement:

UPDATE reminder
set reminderdate = (IF (status = 'Open' and reminded = 'Y'
and autoclose = 'Y' and recur = 'Y',
ADDDATE(reminderdate, INTERVAL occurence occurencetype), reminderdate))

occurencetype can be "DAY", "MONTH" or "YEAR" and stored as a VARCHAR.

Thanks for your help.

Rgds,

How are you calling this? Is it a stored procedure? Are these all fields in the one table?

I reread your post. I think I understand it now. All of those are fields in your table?

I'm assuming it is how you are using ADDDATE(). For the interval type you are inserting a VARCHAR where it is expecting a built-in keyword. I'm assuming that is where the trouble is coming in. I'd assume that sticking in a VARCHAR won't work, but feel free to correct me. What you're doing is essentially:
which doesn't work. But you can stick in ints in there just fine. Something like this will work:
You may want to write a stored procedure to handle it, or throw in more ifs to handle the interval type. I think. Hope that helps some.