RE: [PHP-DB] Determine last quarter

If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) <? $quarter = ceil(date('n')/3); if ($quarter = 1) { $period_first_day = date("Y-m-d", mktime(0,0,0,10,1,date(Y)-1)); $period_last_day = date("Y-m-d", mktime(0,0,0,12,31,date(Y)-1)); } elseif ($quarter = 2) { $period_first_day = date("Y-m-d", mktime(0,0,0,1,1,date(Y))); $period_last_day = date("Y-m-d", mktime(0,0,0,3,31,date(Y))); } elseif ($quarter = 3) { $period_first_day = date("Y-m-d", mktime(0,0,0,4,1,date(Y))); $period_last_day = date("Y-m-d", mktime(0,0,0,6,30,date(Y))); } elseif ($quarter = 4) { $period_first_day = date("Y-m-d", mktime(0,0,0,7,1,date(Y))); $period_last_day = date("Y-m-d", mktime(0,0,0,9,30,date(Y))); } echo "Start of Period: $period_first_day<br>"; echo "End of Period: $period_last_day"; ?> -----Original Message----- From: Rankin, Randy [mailto:randy.rankin@invensys.com] Sent: Tuesday, March 19, 2002 8:57 AM To: php-db@lists.php.net Subject: [PHP-DB] Determine last quarter Hello all, Does anyone know how I might determine the start date and end date of the previous calendar quarter based on today's date. For example, today is 2002-03-19, so the previous quarter start date would return 2001-10-01 and the previous quarter end date would return 2001-12-31. I am trying to determine these dates for a report that generates previous quarter sales based on today (whatever 'today' might be). Hope that's clear. Thanks in advance, Randy Rankin