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?