changed datatype of transaction column to date