rivet Posted March 17, 2003 Posted March 17, 2003 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).
BobWeaver Posted March 17, 2003 Posted March 17, 2003 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.
Recommended Posts
This topic is 7922 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now