Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2062

Re: How To Find All Weeks First date and Last date?

Show all headers | View raw

On 6/9/2011 8:25 AM, Amit Pawar wrote:
> Hi,
>
> I want to find All no of week in any month.
> And first and last date of that week.
>
> Assume Month is Jan 2011
>
> date in Y-m-d
> 1st week ->  Start date=2011-01-01 End date=2011-01-01
> 2nd week ->  Start date=2011-01-02 End date=2011-01-08
> 3rd week ->  Start date=2011-01-09 End date=2011-01-15
> 4th week ->  Start date=2011-01-16 End date=2011-01-22
> 5th week ->  Start date=2011-01-23 End date=2011-01-29
> 6th week ->  Start date=2011-01-30 End date=2011-01-31

First of all, what day does your week start on?  Sunday, from the looks 
of it, but need to be sure.

Next, most calendars would consider that since Jan 1 is on a Saturday, 
that is part of the last week of 2010, and the first week of 2010 would 
start on Jan 2.

So first you need to find the first Sunday. This is pretty easy to do by 
getting the day of week for 2011-01-01 as a number (1-7 for 
Monday-Sunday).  See date() for DateTime::format() with the 'N' format.

 From there it's a simple matter to get the end of the week by adding 6 
days (DateInteral object).  You can then get the start of the next week 
  by either adding 1 day to the end of the week or 7 days to the start 
of the previous week.

Not too hard if you look up the DateTime object in the manual.  It 
contains all the references you need.  See
http://us.php.net/manual/en/class.datetime.php.

(Note: adding 60*60*24*7 seconds will be off by one hour for 1/2 the 
year if you run Daylight Savings Time in the summer - not necessarily a 
problem if you only are interested in dates).

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

How To Find All Weeks First date and Last date? Amit Pawar <amit.pawar@pragmites.com> - 2011-06-09 05:25 -0700
  Re: How To Find All Weeks First date and Last date? Luuk <Luuk@invalid.lan> - 2011-06-09 21:03 +0200
  Re: How To Find All Weeks First date and Last date? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-09 20:03 -0400
    Re: How To Find All Weeks First date and Last date? Jeff North <jnorthau@yahoo.com.au> - 2011-06-10 10:41 +1000

csiph-web