[regression] Searches based on created/modified date don't like certain relative filters
Overview
Any relative date filter on Advanced Search that doesn't calculate both a "From" and "To" date (e.g. "To end of yesterday") result in a "No Such Field" error.
Reproduction steps
- Go to Advanced Search, open Change Log.
- For Created Date, set a relative date filter that doesn't calculate both begin and end date (e.g. "To end of yesterday"). Press Search.
- Get an error
[nativecode=1054 ** Unknown column 'civicrm_contact.created_date' in 'where clause']"]
.
Current behaviour
Incorrect SQL query is constructed.
Expected behaviour
No error.