updated import to stop redundancy, date to from checks, time zone conversion, show all bug