J Jon K Registered User. Local time Today, 21:59 Joined May 22, 2002 Messages 2,207 Oct 3, 2007 #21 A more efficient solution:- FYear: Year([Award Dtd])-([Award Dtd]>=DateSerial(Year([Award dtd]),10,1)) .
A more efficient solution:- FYear: Year([Award Dtd])-([Award Dtd]>=DateSerial(Year([Award dtd]),10,1)) .
