D Douglas J. Steele Jul 31, 2007 #2 Format(Now(), "yyyy") will return a string version of the current year, DatePart("yyyy", Now()) or Year(Now()) will return a numeric version.
Format(Now(), "yyyy") will return a string version of the current year, DatePart("yyyy", Now()) or Year(Now()) will return a numeric version.