How can I create a calculation field that automatically display the current scholar year that start on August and finnish on July?
example: Current Scholar Year: 2004-2005

Hi Juan,

I'm not sure on what day in July or August your year flips over, but there has to be some date. In the calculation below it is assumed to be August 1st, but you can make it whatever you like by changing the month and day of the "changeon" variable.

Hope this helps,

John

Code: Select all

Let ( [
d = Get ( CurrentDate ) ;
changeon = Date ( 8 ; 1 ; Year ( d ) )
] ;

Case (
d >= changeon ;
Year ( d ) & " - " & Year ( d ) + 1 ;
Year ( d ) - 1 & " - " & Year ( d )
) // End Case

) // End Let