added in route column support and fix up some datetime issues