J Jon K Registered User. Local time Today, 03:30 Joined May 22, 2002 Messages 2,209 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)) .
