[RESOLVED] more date stuff. (return days from week number)

[atmorell]

Hello.

I have this small script that returns 7 days when it is supplied with a week number! However it is 6 day off! Week 32 should return 7-13 august 2006 but it gives me 13-19 august 2006? If anyone could assist me I would appreciate it very much.

Best regards.
Asbjørn Morell.

value of year: 2006
value of month: 8
value of week: 32

$day=strftime("%w",mktime(0,0,0,01,01,$this->year)+($this->week_number786400));
$day1=mktime(0,0,0,1,1-$day,$this->year)+($this->week_number786400);
for($count=0; $count<7; $count++) {
echo strftime("%d",$day1+($count*86400));
}

[Weedpacket]

Looks more complicated than it needs to be (and looks less reliable too; some days are not 86400 seconds long).

http://www.phpbuilder.com/board/showthread.php?t=10222903

[atmorell]

I can't get it to work! I used the last example in that thread:

$WeekNo = 31
$Day = 0
$Year = 2006
returns 1970-01-01

    /**
	 * convert week no,Day of week and Year to Date
	 *
	 * @var int $WeekNo - week no (1-52)
	 * @var int $Day - day of the week (0-6) 0-Sunday, 6-Saturday
	 * @var int $Year - Year
	 */
	function week_to_date($WeekNo,$Day,$Year)
	{
		$WeekNo--;
		$week_date = date('Y-m-d',strtotime($Year."-01-04 + ".$WeekNo." weeks"));
		$wDay = date('w',strtotime($week_date));
		if($Day < $wDay){
			$day_offset = $wDay - $Day;
			$date = date('Y-m-d',strtotime($week_date." + -".$day_offset." days"));
		}elseif($Day > $wDay){
			$day_offset = $Day - $wDay;
			$date = date('Y-m-d',strtotime($week_date." + ".$day_offset." days"));			
		}else{
			$date = $week_date;
		}
		return $date;
	}

[Weedpacket]

That's okay; I couldn't figure out what the advantages of that piece of code were either.

[atmorell]

But I need it to work 😉 I can't figure out what is wrong!

[Weedpacket]

Why that code? Did you actually bother to read the thread?

[atmorell]

Yes I did! And I took the last code example I thought it was the correct code. However as I read it again I see that you did a post with some code. Sorry about that. Anyway I tried to use your example however it does not quite return what I expected. year=2006 week number=31 returns: 1154300461 Should it not return the date?

Best regards.
Asbjørn Morell.

[Installer]

That's Unix time. Use the date(), strtotime(), etc. functions with it.

Here's another function to get the timestamp for Monday of week n:

function week_n_ts($wk_num, $yr)
{
    // Count from '0104' because January 4th is always in week 1:
    $wk_day_ts = strtotime($yr . '0104 +' . ($wk_num - 1) . ' weeks');
    return strtotime('-' . (date('w', $wk_day_ts) - 1) . ' days', $wk_day_ts);
 }

Demo:

$ts = week_n_ts($week_num, $year);
$week_start = date('Y-m-d', $ts);
$week_end = date('Y-m-d', strtotime('+6 days', $ts));
$str = 'Week number ' . $week_num . ' of ' . $year . ' is: ';
$str .= $week_start . ' to ' . $week_end;
echo $str . '<br />';

[atmorell]

Thank you. 😃