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.
occurence can be 1,2,3,6,7,10, etc ... as an integer.
If I do the following for example, it works
----------------------------------------------------------------------
UPDATE reminder
set reminderdate = (IF (status = 'Open' and reminded = 'Y'
and autoclose = 'Y' and recur = 'Y',
ADDDATE(reminderdate, INTERVAL occurence DAY), reminderdate))
----------------------------------------------------------------------
Thanks for your help.
Rgds,
