I am trying to run a script in SQL Anywhere 11 to update records based on activity that occured 3 days ago with the DATEADD function.
I am using it as follows:
DATEADD(day, -3, NOW())
Although it runs the script without any reported errors, it doesn't update the records.
If I use the following:
DATEADD(day, -3, '2012-05-23')
It updates the record correctly.
I've tried "GETDATE" with no luck either.
What can I use to replace an actual date for this script?