firstiful hi to all, this is my first message, so this is a great oppurtunity to help a newcomer
my problem is about getting the next monday. it can be in unixtimestamp or in any other time format, it does not matter.
We have an application, where our clients fill a form and post some comments. Because of firm policies, we want to reply all the posts we get daily.
What I need to do is, if a post sent date is saturday or sunday, I want to find the first "next monday" date, and forward these messages to that date.
lets say that ClientA is going to post a message on 19 Saturday 2005. (saturday)
here is the mysql structure:
id / postdate / forwardedtodate / postmessage
what I want is to calculate and get the first monday starting from 19 february. which is 21 february.
anyone knows how can i do that?