I am trying to come up with a calculation that will automatically calculate the school year. Example: 2013-2014
The new school year starts August 1. How would I go about doing this?
Thanks for your help!
Let ( [
theDate = yourTO::yourField ;
theMonth = Month ( theDate ) ;
theYear = Year ( theDate ) ;
theSchoolYear = If (
theMonth ≥ 8 ; theYear & "/" & Right ( (theYear + 1) ; 2 ) ; ( theYear - 1 ) & "/" & Right ( theYear ; 2 ) ) ] ;
That worked great! Thank you so much!!
That worked great! Thank you so much!
Retrieving data ...