March 17, 200322 yr if the user can select which month is the first of the fiscal year. How can you determine what quarter the rest of the months sit in? I have a global field with the month number in it, so let say it is 9 (September).
March 17, 200322 yr Int(Mod(12+nMonth-FiscalStartMonth,12)/3)+1 where nMonth is the month (1..12) that you want to find which quarter it belongs in.
Create an account or sign in to comment