Hi, I can't figure this one out so thought somebody might be able to help.
I need to roll user statistics over on the day of the month that they registered, the problem is that months have different days. Oh and I'm using mysql 3.23 ;-)
Example
join_date='2003-1-5' and I want this months rollover date, so '2004-2-5' would be it
but here is the catch
join_date='2003-4-30' this month would need to return '2004-2-30' which isn't a valid date. Hope this makes sense
