Tests using timezone naive datetime for timezone aware field

[ieaves]

The following warning messages are being emitted for timezone naive test values:

connections/tests/test_tasks.py::TestEventsAllTests::test_dbt_cloud
  /Users/ian/Library/Caches/pypoetry/virtualenvs/the-guide-y4fToIIm-py3.11/lib/python3.11/site-packages/django/db/models/fields/__init__.py:1535: RuntimeWarning: DateTimeField Event.date received a naive datetime (2023-10-09 00:00:00) while time zone support is active.
    warnings.warn(

auth/tests/test_mutations.py::test_verify_email
  /Users/ian/Library/Caches/pypoetry/virtualenvs/the-guide-y4fToIIm-py3.11/lib/python3.11/site-packages/django/db/models/fields/__init__.py:1595: RuntimeWarning: DateTimeField User.verified_at received a naive datetime (2023-10-09 14:25:20.943758) while time zone support is active.
    warnings.warn(

These tests should be modified so that running tests no longer emits the respective warning message.

[kisharnath]

If this is good first issue ,I want to work on this.