# django.core.exceptions.FieldError: Unsupported lookup 'date' for CharField or join on the field not permitted.

- **ID:** `python/django-orm-date-filter`
- **Domain:** python
- **Category:** data_error
- **Verification:** ai_generated
- **Fix Rate:** 80%

## Root Cause

Using __date lookup on a CharField instead of a DateField.

## Version Compatibility

| Version | Status | Introduced | Deprecated |
|---------|--------|------------|------------|
| 3.x | active | — | — |

## Workarounds

1. **** (90% success)
   ```
   Ensure the field is a DateField and use filter(date_field__date=some_date).
   ```

## Dead Ends

- **** — Requires migration and may break existing data. (60% fail)
- **** — Inefficient and error-prone. (50% fail)