Order custom posts by a date metabox

When you’re saving the data on your custom post type you need to set it so that the meta box value is actually stored as a UNIX timestamp, eg:

if(!isset($_POST["event_informations_date"])) {
    return $post;
} else {
    $event_as_timestamp = strtotime ( $_POST["event_informations_date"];
    update_post_meta($post->ID, "event_informations_date", $event_as_timestamp );
}

This way you will have an orderable value for your meta keys. And you can query as per @helgatheviking 

$args = array( 'post_type' => 'Event',
           'posts_per_page' => 1000,
           'order_by' => 'meta_value_num',
            'meta_value' => 'event_informations_date'  );

You will need to make sure that the add_meta_box() function you’re using converts the UNIX timestamp from saved custom field values back to the format you need.

Related Posts:

  1. Help Creating a Slideshow Custom Post Type with Custom Meta Boxes?
  2. Custom Post Type – Taxonomy Dropdown Menu?
  3. How can I add a column/s to wp_posts table?
  4. echo value from ‘select’ field type into page template using cmb2?
  5. How to get custom metabox image field?
  6. Detect meta value changes when post is updated (post_updated)
  7. Custom field being erased after autosave
  8. How to select one major category (or custom taxonomy) for a custom post type?
  9. How to sort CPT by custom meta value (date), and return posts month by month
  10. Use Custom Post Type as Custom Field
  11. Saving multiple Metabox contents
  12. Using ‘strtotime’ function to convert a custom-meta-box to a date-stamp
  13. Metabox saving values
  14. add_meta_box: Datepicker like the one for postdate?
  15. Displaying Meta Box Image
  16. Multiple information using custom post type
  17. how to set default value for checkbox in wordpress
  18. Formatting custom meta box date from YYYY/MM/DD to a more readable alternative
  19. Display custom post on home page based on a metabox selection
  20. Why do I lose the content of meta boxes when I leave the page?
  21. Dynamically add / duplicate custom meta in custom post types
  22. WordPress custom meta field for custom post not storing data
  23. How to Duplicate (multiple meta box)?
  24. window.send_to_editor and jQuery .attr() conflicts with multiple custom upload image meta boxes
  25. List of Posts in a Custom Field
  26. Save an array from drop-down in custom meta box
  27. Populate Custom Fields in a Custom Post Type?
  28. Adding dropdown select meta box to custom post type – seems restAPI is interfering
  29. Keep display metadata value on backend – Custom Metabox
  30. How to check if user meta field is empty in conditional else statement
  31. Why is my select meta data not saving?
  32. dynamically add a custom field or metabox to custom post type [duplicate]
  33. Visual editor issue by having multiple tiny mce editors in a CPT
  34. Found 2 elements with non-unique id (#_ajax_nonce) and (#_wpnonce)
  35. A better way to add a meta box to custom post types
  36. Plugin – Combine Meta Box Input Fields into single saveble record
  37. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  38. Grouping metadatas into one
  39. Repeatable Fields Metabox with Textarea (or wp_editor)
  40. How to use TinyMCE Editor for one of my custom post meta field?
  41. Cannot save CPT meta box
  42. Adding Page Templates to post but it ignored it
  43. Permalinks: custom structure for taxonomy – tags?
  44. Custom “radio button meta box” not saving correctly
  45. Add additional field to custom post_type
  46. Custom Post Meta from custom metaboxes is randomly being deleted
  47. Add a custom meta box for client to order CPT posts how they want
  48. Display Repeatable Meta Box Content
  49. create custom meta box with default value
  50. What do the numbers mean at the end of add_action(‘save_post’)…?
  51. A meta box (in a custom post type) with two different type of fields
  52. Reusable metabox backend and frontend
  53. Get custom term meta problem on single post type
  54. Display custom meta on page that has been check in custom post type
  55. How can I output WPAlchemy repeating fields meta values in my page template?
  56. How can I modify a custom post type and custom page template for a child theme if all content seams to be handled by theme’s ‘native’ plugin?
  57. Adding an extra parameter [string] to my posts’ permalink?
  58. Problem On Retrieving Post Meta Data on Custom Column [closed]
  59. Add a class to post_class if more than one post shares same meta_value_num
  60. Add a meta field to the list of results for a custom post type
  61. Empty meta-box returns publishdate if no value is set?
  62. Saving metabox keys and storing values as array
  63. Custom Post Type Meta Box Text Input Field Won’t Save When Blank
  64. Custom Post Type meta data getting deleted on bulk editing taxonomies
  65. How to avoid duplicate posts queried from custom meta?
  66. Custom Metabox Info Not Saving
  67. PHP Warning with Custom Fields
  68. Problem with multi checkboxes value in metabox?
  69. Simple Data picker meta box
  70. check_admin_referer not working in custom meta box for custom post type
  71. Avoid another meta box in my custom post type
  72. Delete custom post type metadata without deleting the post in admin area
  73. Search form to find custom meta box generated data
  74. Filter CPT based on meta box value using Flexible Posts widget?
  75. Textarea type on one field custom add_meta_box?
  76. WP_Query arguments: Loop through custom post type – get all entries except excluded meta_key?
  77. loop through custom post-type with two meta_keys
  78. Extending a CPT by Created by another plugin
  79. Custom meta box includes
  80. Creating entries with image attachements within posts and managing them in a list
  81. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  82. Adding a custom “Add Custom Field” button to Custom Meta boxes
  83. Display div based on Group metabox selection [closed]
  84. How to consume external API from WordPress post editor and display the response data in the custom field?
  85. How To Set Custom Post Type Title Without Supports
  86. Issue with saving custom post type when editor is removed
  87. WP_Query on custom post type not displaying, multiple loops & get_template_part
  88. Assign Taxonomy Based on Custom Field Value
  89. Assigning the same custom meta box to multiple post types
  90. echo selected value from dropdown
  91. How can I see a list of products that I have set to outofstock through a custom field check box?
  92. Adding a location field to buddypress activity
  93. Custom meta fields not showing up in WP_Response Object via custom endpoint
  94. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  95. Get meta values from parent post and save in child post
  96. CPT and metabox: create multi checkbox by using array?
  97. WP_Query and two custom fields returns no posts
  98. Custom post type Featured Image popup not working
  99. Problems with a custom meta_box
  100. Multiple posts selection [closed]

Leave a Comment