[dihan]

Hi kidz,

My problem

1.
How can I get a date (maybe the first day of that week) of the a selected week from the week number. i.e

If it's the week 42 of 2004 it should be the timestamp of 17th Oct 2004?

D

[Wraith]

Originally Posted by dihan

Hi kidz,

My problem

1.
How can I get a date (maybe the first day of that week) of the a selected week from the week number. i.e

If it's the week 42 of 2004 it should be the timestamp of 17th Oct 2004?

D

The date is best shown using Unix EPoch. Check http://www.php.net/date for details.

-Wraith

[dihan]

I did have a look at that but I cannot figure it out.

It says when you convert the week number to a date it is normally gives the monday of that week. But what is the function/code to get that date?

[dihan]

bump... anyone?

[<?Wille?>]

this will give you the current week number

PHP Code:

echo date('W'); 

[Sabu]

Since I'm in an inventive mood, let's see what my brain can patch together.

Ok, so we know there are about 7 days in a week, yes? And if there are 42 weeks gone by, there are 42*7 days (294)

So we've established the day of the year *but* it will be the same day as the start of the year, since we haven't done anything about the first day of the week or whatnot.

PHP Code:

mktime (0, 0, 0, 1, 294, date("Y")) 

Now this is a disgusting little piece of code that will make your insides curl up and wiggle, but when I tried it out it accepted the "month=1", "day=294" and spat out the 20th of October, later confirmed as the 293rd day of the year. Hey, it's close enough.

Now we have wednesday the 20th of October, we need to sort out the first day of the week. Using date("w") will tell you that Wednesday is the 3rd day of the week (with Sunday as 0)

So now we can do the mktime function again, reducing the days by 3 to get the sunday of that week.

PHP Code:

mktime (0, 0, 0, 1, 291, date("Y")) 

Sun Oct 17, 2004.
date("W") = 42nd week of the year.

Am I good or what?

[dihan]

Thanks for taking the time to post your responce and it works great. My next step is to find the next day (i.e monday, tuesday, etc) by the "date('w) method

This is what I use at the moment to find the Day I want by the 0 - 6 system. What can i do to this script so instead from calculating the day from todays date it will do it by the week number?

PHP Code:

// Select Date Script

$day_of_event = 5 // assuming friday in this example  

$diff = $day_of_event - date('w'); 

$timestamp = strtotime("+" . $diff . " days"); 

I guess I have to get rid of the date number of today ( date('w'); ) and replace it with the week number but that dont seem to work!

[dihan]

somthing like this maybe? Dont work though

PHP Code:

// Get the first day of the week I want.

$week_day = ($promo['weekno'] * 7);

$week_no = mktime (0, 0, 0, 1, week_day, date("Y"));

 

// Select Date Script

$day_of_event = $promo['daysID']; // assuming friday in this example  

$diff = $day_of_event - date('w', $week_no); 

$timestamp = strtotime("+" . $diff . " days"); 

[dihan]

BUMP BUMP.. Anyone?

[dihan]

If no one knows what im trying to do. Please post a responce and I'll try to explain better.