month and day based on week number

no1uknowdfw

Does anyone know how to get the month and day based on the week number strftime(%W)?

Bunkermaster

mySQL has functions to manage that kind of things 🙂 why just use it to store data? have a look here

http://www.mysql.com/doc/en/Date_and_time_functions.html

Tracer

I had a similar problem converting YYYYxxx (such as 2002001 for jan 1, 2002) where xxx was the day of the year and here is the function I used to convert it into a unix timestamp....

//INPUT $string YYYYxxx
//Output = formatted unix timestamp
//mm/dd/YYYY

function rx30_to_human($rxdate)
{
$year = substr($rxdate, 0, 4);
$day = substr($rxdate, -3);

$timestamp=mktime(0,0,0,1,$day,$year);
$result =date('m/d/Y',$timestamp);
return $result;
}

no1uknowdfw

ok I figured it out... basically my ulimate goal was to pull it all into a pulldown menu.... So I wrote a function for anyone who cares...
Hopefully this will be properly formatted in the forum cause it's a long one...

function listbox_week ($name, $default=0) {
$result="<select name=\"$name\" size=1 class=\"formpulldown\">\n";
$weekx = '0';
for ($weekf=strftime("%U"); $weekf>=1; $weekf--) {
$weekx ++;
$str = '-'.$weekf.' week Monday';
if (($timestamp = strtotime($str)) === -1) {
$weekmsg = "The string ($str) is bogus";
} else {
$weekmsg = "Week ".$weekx." - ".date('F j',$timestamp);
$weekdate = date(m.'/'.d.'/'.y,$timestamp);

				}
				if ($default == $weekx) {$selected="selected";} else {$selected="";} 
					$result.="<option value=\"".$weekdate."\" $selected>".$weekmsg."</option>\n";
				} 
	$result.="</select>\n"; 
return $result;

}

echo listbox_week("week", strftime("%U"));