I need to build a system that allows users to query information by quarter, and those quarters are set up based of the fiscal year start. I have an idea of how to do it, but not sure the exact syntax.
$fiscalStart = (from database select)
$q1 = $fiscalStart (but less than 3?)
$q2 = $fiscalStart (+3 but less than 6?)
$q3 = $fiscalStart (+6 but less than 9?)
$q4 = $fiscalStart (+9 but less than 12?)
Am i on the right track?