Week Of Month

[Anon]

A query in one of my PHP scripts returns the datetime. Now from this date field I would like to display something like:

Week [WeekOfMonth] [Month] [Year]

eg: Week 4 Aug. 2000

What format definition do I need to get this right? I tried a few variation but couldn't get it right.

Any help would be great!

[[deleted]]

where do you get the datetime from? MySQL or PHP?

[Anon]

You'll have to break this up in to smaller pieces, because in my PHP manual there is no formatting string which gives the week, so you have to use the number of days and divide it by seven, then subtract the remainder something like this:

$numofdays=date("z");
//this returns the number of days so far this year
$weekofmonth=($numofdays/7)-($numofdays%7);

The rest should be a piece of cake if you take the effort to read the manual, the link is: http://www.phpbuilder.com/manual/function.date.php

DaveTshave

[Anon]

The date("z") thing works but since the actual date is coming from a MySQL database query it doesn't work the way I need it to. Modifying the same to - date("z", $adate) - only returns 0.

[icaro]

function whatsweek($anytime) {
//verify if $anytime is a valid unix time stamp (integer > 0)
$month = date('n', $anytime);
$year = date('Y', $anytime);
$first = mktime(1,1,1,$month,1,$year);
$starts = date('w', $first);// sunday = 0, ... sat = 6
$day = date('j', $anytime);
$firstweek = 7 - $starts;// number of days of the first week
$flag = FALSE;
$analiz_day = $firstweek;
$week = 1;
while ($flag = FALSE) {
if ($day <= $analiz_day) {
return($week);
$flag = TRUE;
} else {
$analiz_day += 7;
$week++;
}
}
}

$anytime is an integer with unix time stamp.
humm.. well, i wrote this at browser, never tested.. it surely contains sintaxe errors..
and i dont know if the while is the best way.. i used thousands of variables, if you are a purist, please dont go die reading this.. 🙂
but i think this is the idea..

[Anon]

I once wrote a VB function to do this. And it worked fine -- until I discovered that some calendar makers do not consider week #1 to be "week #1" in the year if it is a partial week!

IOW, if you look at January for this year, the first week was a partial week (does not contain 7 days). Therefore, some calendar makers will call this week #52 (or possibly #53), not week #1. Week #1, using their system, does not begin until Jan. 7!

I don't know which convention is correct. I suppose you could argue it either way. But it sure plays hell with week numbers.

If anybody knows the official answer to this dilema, please let us all know.

[ashben]

You are right. Anyways, I don't think anybody has further ideas on it.