Re: Date Calculation Help



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

You could do it like this: floor(($month-1)/3)+1;
.