Greetings again,
Well now that the Months in Service coding is working properly (99.999%), I would like to use this calculation a bit further.
I've set up another textbox, Current Contract (Textbox name: CCN), with the coding:
This works fine as well.
It's using this result that's causing the trouble.
I want to generate the current contract's start and end dates.
So far this is what I have as coding for the start date:
What I'm trying to accomplish is this:
If no resignation date exists, then modify the year of the original start date by the number of contracts minus one(1). The moth and day part will remain the same. If there is a resignation date, then display 'N/A'.
The end date would add the full CCN value to the year and subtract one(1) from the day.
Looking at the partial screen shot, it displays '#NAME?'
Any assistance is appreciated.
MNM
Well now that the Months in Service coding is working properly (99.999%), I would like to use this calculation a bit further.
I've set up another textbox, Current Contract (Textbox name: CCN), with the coding:
Code:
=Int((MIS/12)+1)
This works fine as well.
It's using this result that's causing the trouble.
I want to generate the current contract's start and end dates.
So far this is what I have as coding for the start date:
Code:
=IFF(IsNull(Instructor!ResignationDate),(Format(Instructor!NichiiGakkanStart,"yyyy")+[CCN]-1) & "/" & (Format(Instructor!NichiiGakkanStart,"mm/dd"),"N/A"))
What I'm trying to accomplish is this:
If no resignation date exists, then modify the year of the original start date by the number of contracts minus one(1). The moth and day part will remain the same. If there is a resignation date, then display 'N/A'.
The end date would add the full CCN value to the year and subtract one(1) from the day.
Looking at the partial screen shot, it displays '#NAME?'
Any assistance is appreciated.
MNM