Set post date before 1970

Do not use the post_date field for anything it isn’t made for. Use a post meta field instead. The post_date is bound to post_date_gmt, you would get strange side effect even you could get an earlier date into that.

So create post meta fields and query those per tax query. Ignore the default field.

In answer to your comment: Do not use a taxonomy.

  1. Taxonomies are build to allow multiple terms per post (ignore post-formats here). The scheme does not match your use case.
  2. Taxonomy queries are expensive, they run through three tables.
  3. You would have to change the default interface to prevent accidents like multiple assignments. Possible, but not exactly simple and maybe not forward-compatible.

I started a book manager plugin once too, unfortunately it is still in a draft status … but I have some recommendations regarding dates:

  1. Use two post types: one for the opus, one for the real editions (the opus type would be a parent for multiple editions). So you can store the creation date in the opus, the publication date (the language, the editor, translator and so on) in the edition.

  2. Read Making <time> safe for historians. Dates before 1970 are hard.

  3. The MySQL Date and Time Functions cannot handle all cases, you end up with some custom routines for sorting, depending on your solution for (2.).

Related Posts:

  1. Custom Post Type Archives by Year & Month?
  2. How to order posts of a custom post type by date DESC in dashboard Admin?
  3. WP_Query() show posts that end later than today
  4. Uploading DB to server from local is not matching the post dates
  5. Permalinks using event date (year & month) instead of publication date
  6. How to sort CPT by custom meta value (date), and return posts month by month
  7. Date query for a custom meta field
  8. Custom Post Types – How to include custom fields
  9. How to make an archive page displaying posts in a date range
  10. Query current and future events, ordered by begin date
  11. Displaying custom posts only if custom meta box’s date is not expired
  12. Get the next event using date_query
  13. get_queried_object error How to show post count by month in the taxonomy page
  14. Custom Post Type Events Archive Grouped By Month
  15. query_posts with a custom post type, a meta_query and sorting by post date?
  16. Default sort on admin columns with meta date hides draft posts with empty date value
  17. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  18. Post count by month of taxonmy term
  19. Meta Query posts not showing on ending date of custom field
  20. Use the same date-based permalink structure for all post types
  21. How to order posts of a custom post type by date DESC in dashboard Admin?
  22. Order post by date with ACF
  23. Sort custom post type by most current date picker
  24. I am trying to get cutom post cout by month of current taxonmy term
  25. How to display a WordPress Custom Field only on a specific day of the week?
  26. WordPress giving a 404 page when passing a year argument different than the current year
  27. Using WP meta query to show custom post types by a start and finish date
  28. Why does my URL keep returning 404 error code?
  29. Problem with date comparison for custom fields
  30. Using global $post; with custom post types
  31. How to sort WP_Query by a custom text field (written as a date dd/mm/yyyy)
  32. How to set post date in post_type so that it’s same as latest post in category
  33. Display post count for a specific month
  34. Compare ACF Date field to today or yesterday
  35. get_queried_object not work in taxonomy page
  36. Want to display my custom date archive to date.php but dont know how
  37. Pre_get_posts comparison with custom field doesn’t work
  38. Display year value before a set of posts
  39. date archive future posts
  40. Get month and day from a Date Picker custom field
  41. Loop posts in a table ordered by a custom field value
  42. group posts by month/date ignore years
  43. How to get past and upcoming post by defining date in custom field?
  44. How to display custom post type ordered by a custom field date
  45. Change custom post status to draft before today
  46. How to save an integer as taxonomy term?
  47. Generate daily archive whenever any post type is added
  48. Create a list of months based posts
  49. How to randomize published date for WordPress custom post type
  50. ACF Field to set Publish Date – Post Duplication upon Update
  51. Is it possible to specify a time interval (from, to) in ACF with date picker, or other custom field?
  52. Order Wp Query by earliest of 3 dates meta query
  53. WP_Query() displaying past post / event
  54. How to display *block number* instead *date value* on WordPress posts?
  55. How to filter custom posts by tags and custom fields?
  56. Any way to make posts inherit properties/taxonomies through a single assigned taxonomy
  57. Custom post type admin search
  58. How to get my Custom Post Type to display in Recent Posts using “pre_get_posts”
  59. can register_post_type() be safely called before init
  60. Display two post types ordered by two custom fields
  61. Registering post type is not adding to admin menu
  62. Output the content of a term organised by each of the CPT?
  63. Generate Shortcodes by Taxonomy
  64. Pagination is not working on single-{slug}.php but works fine on page-{slug}.php
  65. Add an option in a builder
  66. Trigger email send after custom post publish
  67. What is the best way to correlate one-to-many content-type relationships?
  68. Is there a conditional tag to determine whether the post is _any_ custom post type?
  69. Add field to all custom post types
  70. Single template showing all posts of that type
  71. Cluster CPT posts to users based on ACF value from their profile on dashboard
  72. How can you use one database with multisite
  73. List Taxonomies: Don’t list taxonomy if it has no post – depending on custom post-meta?
  74. Target post type edit page to change view post button, how do I?
  75. Including link to custom post type in ‘wp_list_pages’ function
  76. Creating tags via API
  77. WP_Query Custom Post Type if Category ID Equals
  78. Select2 AJAX and WP Query Returns ALL and does not filter
  79. Show categories of custom post type and not all posts
  80. Reusable metabox backend and frontend
  81. How to loop through custom post type items and add them to a slider if they exist
  82. Custom post type (Jigoshop): unexpected value for $category_id (via $term->term_taxonomy_id) on live server
  83. Use Gravity Forms and a Shopping Cart for output to Freshbooks for an Estimate [closed]
  84. Displaying taxonomies as category links within sidebar and creating pages for these
  85. Can I bind a post_type=’post’ category to a custom post_type category?
  86. Add custom posts to submenu automatically
  87. Custom taxonomy: on the taxonomy term page show other taxonomy terms
  88. Get next and prev item from custom WP_Query and Custom Post Type
  89. wp_set_object_terms creates taxonomies but does not add custom posts to it
  90. Make bootstrap 5.0 carousel dynamic using ACF and CPT UI [closed]
  91. Custom post categories are not displaying on the page
  92. Get posts under custom taxonomy and custom post type
  93. Flush rewrite rules when new cpt is registred
  94. Custom field linking problem!
  95. Custom Post Type and Custom Taxonomy not connected
  96. How to Associate Posts with Pages
  97. how to show Author post type count
  98. What is the code for showing Custom Category and Subcategory Page?
  99. Show custom category archive as front page and remove taxonomy slug from urls
  100. Meta_query question

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)