Himitsu Posted February 28, 2005 Share Posted February 28, 2005 I have been at it and I know my understanding of if statements isn't that good. But what I am tring to do is produce a kind of school year calculation based on stopping date. I have a field that contains when the student stopped. I also made two more calculation fields that pull the date into year and month. What I need is a field that states: if( stopped_month >=4; stopped_year & "-" & stopped_year + 1) but it only produces a number 1. What I need it to do is have a school year starting from april to end of march the next year. So if a student stopped 2004/5/12 then I need the calculation to produce 2004-2005. Any ideas? Thanks Ryan Link to comment Share on other sites More sharing options...
This topic is 6599 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 account
Already have an account? Sign in here.Sign In Now