Jump to content

Archived

This topic is now archived and is closed to further replies.

defcon2000

WHAT IS WRONG WITH THIS, HELP PLEASE

Recommended Posts

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.

occurenace can be any value such as 1, 2, 5, 12, 10, etc ... and is an INT.

 

Thanks for your help.

 

Rgds,

Share this post


Link to post
Share on other sites

The date function is called DATE_ADD(), not ADDDATE() -- this should resolve your syntax error, assuming everything else is OK.

 

Hope that helps.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.