I'd been trying to do date range comparisons all day, and found that using sql was the only way to find out if a date (inside a table) was between a range (assigned by me)
You should be able to do this with some php.
You can use the strotime() function to turn the date from the table into a timestamp. Then use strotime to turn your start and end dates into a timestamp. Then do a simple if statement comparison - if the start date is less than the table date and the table date is less than the end date... you're good.
You could create an array, with four elements. Each one of those elements would be its own array - with a start date, end date, and quarter name.
Then loop through the entire array, do the if comparison, and when you have a match save the quarter name.
Here's a working script to get you started. You'd just need to punch in your data from the db table and add the correct date ranges in.
<?php
$test_date = strtotime("21 June 2008");
$quarters = array();
$season['start'] = strtotime("1 January 2008");
$season['end'] = strtotime("1 April 2008");
$season['name'] = 'First';
$quarters[] = $season;
$season['start'] = strtotime("1 April 2008");
$season['end'] = strtotime("1 July 2008");
$season['name'] = 'Second';
$quarters[] = $season;
$active_quarter = '';
foreach ($quarters as $one)
{
if (($one['start'] < $test_date) && ($test_date < $one['end']))
$active_quarter = $one['name'];
}
if ($active_quarter != '')
echo "Match: $active_quarter";
else
echo "No match!";
?>
Reputation Points: 29
Solved Threads: 5
Junior Poster in Training
Offline 57 posts
since Jan 2008
Unsolved 
