Is it a date field or a date time field?
Date fields in ACF are not stored in standard DB date formats. You cannot use 'type' => 'DATE'
with these fields. You need to use wither number or char as type. The format of the value in the DB is “YYYYMMDD” or in standard date notation ‘Ymd’