Echo page title from page with custom meta datetime picker

Question

I am using Custom Metaboxes and Fields for Wordpress

I am using the datetime_timestamp custom meta with a page. I am trying to echo the title of the page I am using the custom meta datetime in. But it is not working. I have the code incorrect. And I may possibly be far off!

I have the code in the header, and I want to display 1 with the closest datetime.

global $post;
$text = get_post_meta( $post->ID, '_cmb_test_datetime_timestamp', true );
$time = current_time( 'Y-m-d' );
if ($text <= $time)
  echo $post->post_title;

It is displaying the title of the most recent title when viewing a page of post. Or if I am viewing a single post page it displays that post title.

I think I might need to make a custom loop possibly. I am a bit lost.

Answer 1

This should output the title of the page with the most recent timestamp:

$args = array(
    'post_type' => array( 'page' ),
    'order' => 'DESC',
    'orderby' => 'meta_value_num', // Note was `meta_value` before
    'meta_key' => '_cmb_test_datetime_timestamp',
    'numberposts' => 1,
);
$posts = get_posts( $args );
if ( $posts ) echo $posts[0]->post_title;
wp_reset_postdata();

To add conditions, use a meta_query clause, eg

$midnight = strtotime( date( 'Y-m-d', time() + DAY_IN_SECONDS ) );
// If setting timezone when saving data, $midnight += get_option( 'gmt_offset' ) * HOUR_IN_SECONDS;
$args = array(
    'post_type' => array( 'page' ),
    'order' => 'DESC',
    'orderby' => 'meta_value_num', // Numeric sort.
    'meta_query' => array(
        array(
            'key' => '_cmb_test_datetime_timestamp',
            'compare' => '<',
            'value' => $midnight,
            'type' => 'UNSIGNED', // Note was missing before.
        ),
    ),
    'numberposts' => 1,
);