Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

Sorting meta box values by start- and enddate and all dates in between

I think you can do the trick running 2 loops, in the first you prepare an helper array of posts ordered by date, in the second you display this array:

Something like this (completely untested):

if ( $agenda_query_full->have_posts() ) {
  $date_events = array(); // helper array
  $today = date('Y-m-d');
  while ( $agenda_query_full->have_posts() ) {
    $agenda_query_full->the_post();
    global $post;
    $metas = get_post_custom();
    // save event name in the post object
    $post->ename = array_pop( $metas['evenement-name'] ); 
    $meta_event_start = array_pop( $metas['evenement-datum-start'] );
    $meta_event_end = array_pop( $metas['evenement-datum-end'] );
    $dateRange = getDateRange( $meta_event_start, $meta_event_end ); 
    asort($dateRange);
    foreach ( $dateRange as $date ) {
      if( $date < $today ) continue; // skip past events
      if ( ! isset($date_events[$date]) ) $date_events[$date] = array();
      $date_events[$date][] = $post; // put post in helper array that is keyed by date
    }
  }
  if ( ! empty($date_events) ) {
    foreach ( $date_events as $date => $events ) {
      $datum = date( "d-m-Y", strtotime($date) );
      echo '<h3>' . $datum . '</h3>';
      echo '<ul>'; 
      foreach ( $events as $event ) {
        if( in_category( 'acties', $event ) ){
        echo '<li><a href="' . get_page_link( $event->ID ) . '">' . $event->ename . '</a></li>';
        } else {
        echo '<li>' . $event->ename . '</li>';
        };
      }
      echo '</ul>';
    }
  } else {
    echo 'No events found.';
  }
} else {
    echo 'No events found.';
}
wp_reset_postdata();

Related Posts:

  1. Why time functions show invalid time zone when using ‘c’ time format?
  2. Query between two meta values?
  3. How to show Published date and/or Modified date
  4. Time & Date on Post – Time Ago Custom Function
  5. Sort custom posts in archive by multiple values: date AND meta key
  6. Randomizing Post Links Outside of Loop – No Author or Date
  7. Post Publish date not display on Umaya Child themes
  8. How to sort by meta value num, but ignore zero value?
  9. Update event post meta each day automaticaly
  10. Posts with no meta field do not appear when sorting by meta field
  11. How do I retrieve the slug of the current page?
  12. Most efficient way to get posts with postmeta
  13. Get posts by meta value
  14. Can the Next/Prev Post links be ordered by menu order or by a meta key?
  15. Explanation of update_post_(meta/term)_cache
  16. How to extract data from a post meta serialized array?
  17. How to save an array with one metakey in postmeta?
  18. WordPress is stripping escape backslashes from JSON strings in post_meta
  19. How can I get the post ID from a WP_Query loop?
  20. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  21. Orderby meta_value only returns posts that have existing meta_key
  22. Order by meta value or date?
  23. How to update_post_meta value as array
  24. Adding meta tag without plugin
  25. What’s the point of get_post_meta’s $single param?
  26. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  27. How to edit a post meta data in a Gutenberg Block?
  28. Sanitizing integer input for update_post_meta
  29. post formats – how to switch meta boxes when changing format?
  30. Execute action after post is saved with all related post_meta records (data)
  31. Lack of composite indexes for meta tables
  32. Get a single post by a unique meta value
  33. if get_post_meta is empty do something
  34. How we get_post_meta without post id
  35. How get post id from meta value
  36. What is the code to get the download link for a product in WooCommerce?
  37. Safe to delete blank postmeta?
  38. advanced custom fields update_field for field type: Taxonomy
  39. update_post_meta not saving when value is zero
  40. Content hooks vs User hooks
  41. Meta compare with date (stored as string) not working
  42. Sorting a query by custom field date
  43. Auto sort the wp-admin post list by a meta key
  44. Ordering posts having multiple post-meta date fields
  45. Trying to get custom post meta through Jetpack JSON API [closed]
  46. How to update/insert custom field(post meta) data with wordpress REST API?
  47. Restrict post edit/delete based on user ID and custom field
  48. get_post_meta returning empty string when data shows in the database
  49. publish_post action hook doesn’t give post_meta_data
  50. Remove WordPress.org Meta link
  51. Remove post meta keys
  52. How to access the post meta of a post that has just been published?
  53. Why is get_post_meta returning an array when I specify it as single?
  54. How to update/delete array in post meta value?
  55. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  56. Adding an assisting editor box to Post page
  57. delete unused postmeta
  58. Should I sanitize custom post meta if it is going to be escaped later?
  59. Add post meta based on another post meta value before publish post
  60. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  61. Front-end update_post_meta snippet displays white screen?
  62. Save both current and new version of post meta
  63. Get Advanced Custom Fields values before saving [closed]
  64. Give extra post-meta to RSS feeds
  65. How to get meta value in wp_attachment_metadata
  66. WP REST API “rest_no_route” when trying to update meta
  67. Clean up output added via wp_head()
  68. List posts under meta_value heading
  69. Why am I getting an infinite loop with have_posts?
  70. get_post_meta – get a single value
  71. delete value 0 in post meta [closed]
  72. Can I safely delete a record, manually, in the wp postmeta table?
  73. WordPress Menu Disappears when $query->query_vars[‘meta_key’] is set
  74. sort events based on event date custom field
  75. How to store post meta in an array?
  76. What action hook updates post meta?
  77. Can’t translate the post meta data (Date) in another language
  78. get_post_meta / update_post_meta array
  79. adding a URL to a post meta
  80. Exclude a category from the filed under list
  81. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  82. How do I access post meta data when publishing a new post in Gutenberg?
  83. update_post_meta() not working when used with WordPress action
  84. Using Advanced Custom Field (ACF) to insert meta description on each page
  85. Triple meta_key on custom SELECT query
  86. get_post_custom()
  87. Adding meta data to an attachment post
  88. update_post_meta not adding anything.(Nor add_post_meta)
  89. loop through all meta keys with get_post_meta
  90. Get posts by meta value with date
  91. How to add meta tag to wordpress posts filter?
  92. Are multiple values from get_post_meta guaranteed to be ordered?
  93. Identifying Importer Posts
  94. Get updated post meta on save_post action?
  95. Get post from meta_key and meta_value
  96. Add a post metadata if only the key and value does not exist
  97. get_post_meta returns bool(false)
  98. How metadata API works?
  99. Correct processing of `$_POST`, following WordPress Coding Standards
  100. Formatting custom meta box date from YYYY/MM/DD to a more readable alternative
Categories post-meta Tags date-time, events, post-meta, sort
How to retrieve hashtaged tweets from a list of users and post to WordPress
WordPress installation self deleted in server restart. SQL Tables gone too!

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress