Financial Year Dates

The_Chancer

Tired of working out when 13weeks from the last period end ???

This does it for you...

<html>
<head>
<title>Financial Year Calculations</title>
</head>
<body>
<form name="quarters" action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<select name="year">
<?php 
for($i=2004;$i<2101;$i++)
{
	echo "\n<option value=\"".$i."\""; if ($_POST['year']==$i){echo "SELECTED";} echo ">".$i."</option>";
}
?>
</select>
<br />
<select name="quarter">
<option value="1" <?php if ($_POST['quarter']==1){echo "SELECTED";}?>>Quarter 1</option>
<option value="2" <?php if ($_POST['quarter']==2){echo "SELECTED";}?>>Quarter 2</option>
<option value="3" <?php if ($_POST['quarter']==3){echo "SELECTED";}?>>Quarter 3</option>
<option value="4" <?php if ($_POST['quarter']==4){echo "SELECTED";}?>>Quarter 4</option>
</select>
<br />
<input type="submit" name="submit" value="Show Quarter figures">
</form>

<?php
if (isset($_POST['submit']))
{
	$findend=86400+findEnd(strtotime("31 March ".$_POST['year']." 00:00:00 GMT"));
	$week=7*86400;
	echo "Starts on: ".date("d D M Y",(86400+findEnd((($findend)+((13*($_POST['quarter']-1))*$week)))))."<br />";
	echo "Ends on: ".date("d D M Y",findEnd((($findend)+((13*$_POST['quarter'])*$week))))."<br />";
}
function findEnd($date)
{
	switch($date)
	{
		case(date("D",$date)=="Sun"):
		$end=$date-86400;
		break;
		case(date("D",$date)=="Mon"):
		$end=$date-(86400*2);
		break;
		case(date("D",$date)=="Tue");
		$end=$date-(86400*3);
		break;
		case(date("D",$date)=="Wed");
		$end=$date+(86400*3);
		break;
		case(date("D",$date)=="Thu");
		$end=$date+(86400*2);
		break;
		case(date("D",$date)=="Fri");
		$end=$date+(86400*1);
		break;
		case(date("D",$date)=="Sat");
		$end=$date;
		break;
	}
	return $end;
}
?>
</body>
</html>

drawmack

pretty cool, though since this would mainly be used for businesses you should check if the generted date is on a weekend and if so move it accordingly so that quarters always start would be moved to monday and quarter end would be moved to a friday.

BuzzLY

FYI, the proper way of designating an option as selected is:

[FONT=courier new]<option value="foo" selected="selected">foo</option>[/FONT]

The_Chancer

Damn that selected="selected"... Oh well...

As to the financial year dates - they are based on the UK tax dates. The end of the financial year ends on the Saturday closest to the 31st March...
Why - I don't know - all I did was work it out... then 13 weeks carries on from there...

Here is the amended code - courtesy of Buzzlys suggestion...

<html>
<head>
<title>Financial Year Calculations</title>
</head>
<body>
<form name="quarters" action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<select name="year">
<?php 
for($i=2004;$i<2101;$i++)
{
    echo "\n<option value=\"".$i."\""; if ($_POST['year']==$i){echo "selected=\"SELECTED\"";} echo ">".$i."</option>";
}
?>
</select>
<br />
<select name="quarter">
<option value="1" <?php if ($_POST['quarter']==1){echo "selected=\"SELECTED\"";}?>>Quarter 1</option>
<option value="2" <?php if ($_POST['quarter']==2){echo "selected=\"SELECTED\"";}?>>Quarter 2</option>
<option value="3" <?php if ($_POST['quarter']==3){echo "selected=\"SELECTED\"";}?>>Quarter 3</option>
<option value="4" <?php if ($_POST['quarter']==4){echo "selected=\"SELECTED\"";}?>>Quarter 4</option>
</select>
<br />
<input type="submit" name="submit" value="Show Quarter figures">
</form>

<?php
if (isset($_POST['submit']))
{
    $findend=86400+findEnd(strtotime("31 March ".$_POST['year']." 00:00:00 GMT"));
    $week=7*86400;
    echo "Starts on: ".date("d D M Y" ,(86400+findEnd((($findend)+((13*($_POST['quarter'
]-1))*$week)))))."<br />";
    echo "Ends on: ".date("d D M Y" ,findEnd((($findend)+((13*$_POST['quarter'])*$week
))))."<br />";
}
function findEnd($date)
{
    switch($date)
    {
        case(date("D",$date)=="Sun"):
        $end=$date-86400;
        break;
        case(date("D",$date)=="Mon"):
        $end=$date-(86400*2);
        break;
        case(date("D",$date)=="Tue");
        $end=$date-(86400*3);
        break;
        case(date("D",$date)=="Wed");
        $end=$date+(86400*3);
        break;
        case(date("D",$date)=="Thu");
        $end=$date+(86400*2);
        break;
        case(date("D",$date)=="Fri");
        $end=$date+(86400*1);
        break;
        case(date("D",$date)=="Sat");
        $end=$date;
        break;
    }
    return $end;
}
?>
</body>
</html>

BuzzLY

Something else to consider, too. I'm not sure if this code is physically faster, but it's shorter and cleaner:

function findEnd($date) {
  $dow = array("Sun" => -1,"Mon" => -2,"Tue" => -3,
    "Wed" => 3,"Thu" => 2,"Fri" => 1,"Sat" => 0)
  $end = $date + (86400 * $dow[date("D",$date)]);
}

In fact, if you wanted to do it mathematically, that's a possibility too. The good thing about this is that it's easily adjustible:

function findend($date) {
  $datetime = $date-259200; // subtract 3 days;
  $end = date(r,$datetime + 86400*(6-date(w,$datetime)));
}