meta_query not working on live site

My reputation is too low for me to comment so I’ll do it this way.

Make sure that the date format inside ‘value’ is the same as the date formats inside the database fields. Also don’t forget to add the ‘type’ => ‘DATE’ to your query. An example of some code that I’ve used in the past:

$queryArgs['meta_query'] = [
    [
        'relation' => 'OR',
        [
            'key' => '_ys_brochures-offline-date',
            'value' => date('Y-m-d'),
            'compare' => '>',
            'type' => 'DATE' // notice the 'DATE'
        ],
        [
            'key' => '_ys_brochures-offline-date',
            'compare' => 'NOT EXISTS',
        ],
    ]
];