formatting
make sure parsed times are set to UTC
convert datetime.now() to datetime.now(UTC) for xqueue
convert all datetime.now() to datetime.now(UTC)