convert date and strip string values