Re: Date Calculation Help

At 6/30/2007 08:14 AM, revDAVE wrote:

I have segmented a year into four quarters (3 months each) nowdate = the month of the chosen date (ex: 5-30-07 = month 5) Q: What is the best way to calculate which quarter (1-2-3 or 4) the chosen date falls on? Result - Ex: 5-30-07 = month 5 and should fall in quarter 2

If you divide the month number by 3 you get:

1       0.333333333
2       0.666666667
3       1
4       1.333333333
5       1.666666667
6       2
7       2.333333333
8       2.666666667
9       3
10      3.333333333
11      3.666666667
12      4

The first digit is off by one, so subtract .1 from each result:

1       0.233333333
2       0.566666667
3       0.9
4       1.233333333
5       1.566666667
6       1.9

etc. Now you can see from the first digit that if you take the integer value and add 1 you'll get:

1       1
2       1
3       1
4       2
5       2
6       2

etc. In PHP this could be:

        intval(($month - .1)/3 + 1)

or:

        intval(($month + .9)/3)

I believe you can use intval() and floor() interchangeably in this circumstance. Regards, Paul __________________________ Paul Novitski Juniper Webcraft Ltd. http://juniperwebcraft.com