[UPHPU] mysql date calculation bug

[Ben Reece]

Jim Anderson wrote:
> A good suggestion. I thought of that as well, but seem to remember 
> coming across similar issues. I've had about 15 things in my head 
> throughout the day so I may be getting some of my issues/projects 
> schmeared though. Do you think doing it that way would skip over 
> anyone? I saw that as an unlikely, but possible, concern.
>
> i was thinking something like:
>
> WHERE DATE_ADD(start_date, INTERVAL 6 MONTH) + INTERVAL 45 DAY = 
> CURDATE()
>
> but i haven't had the time to test it out.
>
> to fill out the scenario a bit fuller, the criteria is this:
>
> * 9 different emails. one for each of the following date scenarios.
> * six months after sign-up minus 45 days
> * six months after sign-up minus 30 days
> * six months after sign-up minus 15 days
> * six months after sign-up minus 5 days
> * six months after sign-up [minus 0 days]
> * six months after sign-up plus 15 days
> * six months after sign-up plus 30 days
> * six months after sign-up plus 45 days
> * six months after sign-up plus 60 days
>
> That is the schedule that i have in place.
>
> -jim
I don't see any problem with that statement -- seems like it would work 
without any problems.  The only possible issue would be that the emails 
might not be the exact number of days apart that you show, since you're 
adding months, and the date can move a little bit because of that. 

Ben