If this is a date field (not a date time field) then your issue lies in the fact that ACF does not store “Date” values in the DB for the field. The values are in the format of “YYYYMMDD”. You’re queries must be on either “CHAR” or “NUMERIC” comparisons and any calculations based on the date must use this format.
