Draft standard post by ACF Data picker

Question

I have a custom field named "fecha_borrado". The date is a date picker from Advanced Custom Field.

I have this code but don't work. Maybe i did some wrong?

I added too define('ALTERNATE_WP_CRON', true); in my wp-config file

// expire offer posts on date field.
if (!wp_next_scheduled('expire_posts')){
  wp_schedule_event(time(), 'hourly', 'expire_posts'); // this can be hourly, twicedaily, or daily
}

add_action('expire_posts', 'expire_posts_function');

function expire_posts_function() {
    $today = date('Ymd');
    $args = array(
        'post_type' => array('post'), // post types you want to check
        'posts_per_page' => -1 
    );
    $posts = get_posts($args);
    foreach($posts as $p){
        $expiredate = get_field('fecha_borrado', $p->ID, false, false); // get the raw date from the db
        if ($expiredate) {
            if($expiredate < $today){
                $postdata = array(
                    'ID' => $p->ID,
                    'post_status' => 'draft'
                );
                wp_update_post($postdata);
            }
        }
    }
}

Answer 1

This code works perfectly!

function delete_expired_posts() {
$args = array(
    'post_type' => 'post',
    'meta_query' => array(
        array(
            'key' => 'fecha_borrado', 
            'compare' => 'EXISTS',
        ),
    ),
    'posts_per_page' => -1, 
);

$query = new WP_Query($args);

if ($query->have_posts()) {
    while ($query->have_posts()) {
        $query->the_post();
        $post_id = get_the_ID();

        $acf_date = get_field('fecha_borrado', $post_id); 
        $acf_timestamp = strtotime($acf_date);
        $current_timestamp = time();

        if ($acf_timestamp && $acf_timestamp < $current_timestamp) {
            wp_delete_post($post_id, true); // Permanently delete post
        }
    }
}

wp_reset_postdata();
}

if (!wp_next_scheduled('delete_expired_posts_daily')) {
wp_schedule_event(time(), 'hourly', 'delete_expired_posts_daily');
}
add_action('delete_expired_posts_daily', 'delete_expired_posts');