MMDDYYYY2 Digit Month, 2 Digit Day, 4 Digit Year
References in periodicals archive ?
Text and Data Functions Name Arguments Example LEFT ([Field Name], # of Middle characters on left) Initial:Left([FirstName],1) RIGHT ([Field Name], # of LastFourDigitsOfSSN: characters on right) Right([SocialSecurityNumber],4) MID ([Field Name], Day for a text date MMDDYYYY: Starting Position, # MID([TextDate],3,2) of MONTH ([DateField]) BirthMonth:Month([Birthdate]) YEAR ([DateField]) YearHired: Year([HireDate])