I'm not sure what's happening here as I'm sure this was working previously but:
I have a query that displays a list of Tasks. I need to display all of the Tasks for the next 7 days, so we'll see
a) all of the tasks for today
b) all of the tasks for the next 7 days
c) all of the tasks that are incomplete from the past. ('In Progress' as opposed to 'Complete')
My query is as follows:
FIND Task WHERE Task.Status='In Progress' AND Task.StartTime>=DATE_ADD(CURRENT_DATE,7)
But it seems to be adding MONTHS instead of DAYS? If I log in and check, I see tasks for months ahead?
I thought DATE_ADD was for adding/subtracting days, according to the manual.
Or am I being daft?
