used shorter dates on tests
updated data types from date to varchar(12)