dat = CDate("11/23/2008") ' dd/mm/yyyy format is assumed dat = CDate("23/11/2008") ' mm/dd/yyyy format is assumed