revise date format of collected column for early measures