How to store datetime from custom meta box so that it can be sorted by

Post meta is stored in the wp_postmeta table. Values are stored as longtext, not as dates or integers.

So your safest bet is to store these datetime fields as Unix timestamps. Then you can sort them using a meta query.

Related Posts:

  1. Custom Post Type Data in Sidebar widgets?
  2. How to filter custom posts by tags and custom fields?
  3. How to order adjacent posts (prev / next) by custom field value?
  4. Hide custom post type field from author?
  5. Many to Many Relationship between Two Custom Post Types
  6. Sorting a query by custom field date
  7. echo value from ‘select’ field type into page template using cmb2?
  8. wordpress plugin error handling
  9. Creating Photo Gallery System with Custom Post Type
  10. Set post title from two meta fields
  11. How to sort CPT by custom meta value (date), and return posts month by month
  12. How to solve suspected memory issue in custom WordPress loop?
  13. Trying to save custom post type from frontend partially working
  14. Custom Taxonomy order by Custom Field
  15. Comparing timestamps in meta query doesn’t work
  16. Display two post types ordered by two custom fields
  17. Is there any performance consideration when using Custom Post Types?
  18. Custom Post Type Navigation on Custom Field
  19. how to interconnect custom post types?
  20. WP All Import – Using Xpath to set a select value
  21. Adding dropdown select meta box to custom post type – seems restAPI is interfering
  22. Automatically update custom field in all posts of a custom post type
  23. search also in taxonomy, tags and custom fields
  24. Add field to all custom post types
  25. Filter custom posts using auto populated dropdown selectors
  26. Querying Two Custom Post Types with OR Not Working
  27. How can I get the number of custom post type posts that have a specific attachment image set?
  28. Bulk Update Custom Fields for Custom Post Types
  29. Add custom field to Posts and sort by it
  30. Two Custom Post Types Many to Many Relationship
  31. Including metaboxes from custom post types in global search — continued
  32. Show image gallery from a custom field
  33. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  34. filter custom post in rest api with custom function
  35. Custom Fields for Custom Post [closed]
  36. Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
  37. Adding Page Templates to post but it ignored it
  38. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  39. Is there any way to add a “custom field” to the CPT archive page?
  40. How to let users choose where to search for posts?
  41. don’t publish custom post type post if a meta data field isn’t valid
  42. WebP Fallback for Inline Background Image in Style Attribute
  43. How can meta boxes be added to “unknown” custom posts?
  44. Custom “radio button meta box” not saving correctly
  45. Check if post with same meta value exists
  46. Custom posts type for individual pages?
  47. custom post data – how to
  48. Get Post Terms of Current Post (selected taxonomy term) – How to get only the taxonomy value and not “Array ( [0] => taxonomy term )” in the frontend?
  49. WP Query ‘posts_per_page’
  50. Custom Post Type Metadata Not Saving
  51. Editor / Add Media: Is it possible to only allow galleries?
  52. What do the numbers mean at the end of add_action(‘save_post’)…?
  53. A meta box (in a custom post type) with two different type of fields
  54. Many to many to many custom post relationships
  55. copy images from custom field to another custom field
  56. Custom Query: If One Post Object Field Value Is The Same As Another
  57. How to migrate Custom Field Template to a WordPress Multisite
  58. Sum and count of custom field values
  59. Reusable metabox backend and frontend
  60. Cannot obtain custom meta information
  61. How to use a specific custom field in a custom post type as slug
  62. How do I show my containing my custom field ONLY if there is a set value on that custom field? [closed]
  63. How to hide a custom field from admin?
  64. How to import database table as custom post type and custom fields?
  65. Adding an extra parameter [string] to my posts’ permalink?
  66. Add Extra Category Field to CPT Categories
  67. Cache issue with WP_Query and custom field filtering
  68. Fill custom fields when saving custom post types
  69. Empty meta-box returns publishdate if no value is set?
  70. Custom Post Type Meta Box Text Input Field Won’t Save When Blank
  71. Use Gravity Forms and a Shopping Cart for output to Freshbooks for an Estimate [closed]
  72. Alike Shortcode using in Custom Shortcode
  73. wp_set_object_terms creates taxonomies but does not add custom posts to it
  74. Why this didn’t work if i use get_the_ID(), but works if i pass the numeric id
  75. What is the correct way that when creating a custom post type assign values to custom fields created with pods framework?
  76. Custom Metabox Info Not Saving
  77. Post Filtered by Custom Field Value
  78. Autofill advanced custom field with user data
  79. Advanced search form with multiple custom fields
  80. Meta_Query refuses to return results
  81. Multi Photo Upload with Caption on Front End for Custom Post Type
  82. Search facility with directories
  83. How to make a shortcode for my WP_Query Loop? [duplicate]
  84. WordPress is giving a warning but my code is working fine
  85. Query events post type after current date and timezone
  86. Avoid another meta box in my custom post type
  87. Can’t pick up a field created with Advanced Custom Fields
  88. Pre_get_posts comparison with custom field doesn’t work
  89. How to stop wp_query searching pages as well as the specified CPT
  90. Post content is cleared when updating
  91. Unable to get the upcoming events for custom post
  92. Custom field totals
  93. custom taxonomies are not showing up in get_taxonomies
  94. How can i display on front page a movie that is atached in a post type
  95. Types plugin isn’t compatible with my custom post type
  96. Show Posts in Vertical Tabs with Scrollbar
  97. How do I filter a custom post type loop by a field?
  98. Custom Post type as Taxonomy
  99. Display div based on Group metabox selection [closed]
  100. Custom Sort Order for Custom Post Type Taxonomy