Finding the next Monday.

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I can find the next week by using something simlilar to this.

Code:

SELECT DISTINCT DATEADD('week',1,'move_dt') AS nextmove


FROM tracking

But what if I wanted to find the next Monday regardless of when this query ran?

Posted: Wed Jan 03, 2007 9:16 am

Do you have to do it in SQL? It is easier to do those type of calculations in PHP.
strtotime() is your friend. [ Only registered users can see links on this board! Get registered or login! ]