Pls tell me what is wrong with my statement:
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.
occurenace can be any value such as 1, 2, 5, 12, 10, etc ... and is an INT.
Thanks for your help.
WHAT IS WRONG WITH THIS, HELP PLEASE
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users