fixed a bug with generating the ban date, switched to aggregations