Calculate date of "next sunday" 1

[Microbe]

Hey there, how do I calculate the date of "next Sunday"?

Thanks in advance

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.

 

[Olavxxx]

Hi, look at this:

http://no.php.net/manual/en/function.getdate.php

You can check the wday diff vs. todays wday..
eg. Sunday = 0, if wday == 1, you know that it's 6 - 1 days untill it's sunday.

It's way more simple in mysql though, so if you are querying your db, I would do it there..

Eg. you could do in mysql:

mysql> SELECT STR_TO_DATE('200442 Monday', '%X%V %W');
        -> '2004-10-18'

Or, you could use PHP and mysql, pass the difference from above and use the DATE_ADD mysql function, in cooperation with now() / timestamp.

There might be a way to do it in php too, but I think it's easiest to do it in mysql, if your running a query when you want it extracted.


Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[jpadie]

date ("j/m/Y", strtotime("next Sunday"));

yup - it's that easy...

 

[Microbe]

Thanks for that

I am doing the calculation to put a default "week ending date" into a form, so jpadie's answer is perfect.

I appreciate you both answering.

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.