Date Calculation Help



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



--
Thanks - RevDave
CoolCat@xxxxxxxxxxxxxxxx
[db-lists]
.