Modifying date filter on admin page for custom post type to link to custom field

Use the pre_get_posts action to override the default query. In the admin, a date query will be the query var m in the format YYYYMM. Assuming your meta dates are stored the same as MySQL dates (YYYY-MM-DD), you can use the following:

function wpse_189824_date_meta_query( $wp_query ) {
    if ( is_admin() && $wp_query->is_main_query() && $wp_query->get( 'post_type' ) === 'sermons' ) {
        if ( $m = $wp_query->get( 'm' ) ) {
            $y = substr( $m, 0, 4 ); // Year
            $m = substr( $m, 4, 2 ); // Month

            if ( ! $meta_query = $wp_query->get( 'meta_query' ) ) // Keep meta query if there currently is one
                $meta_query = array();

            // Using LIKE query

            $meta_query[] = array(
                'key' => 'recorded_date',
                'value' => "$y-$m-%",
                'compare' => 'LIKE',
            );

            /*

            // OR using DATE

            $meta_query[] = array(
                'key' => 'recorded_date',
                'cast' => 'DATE',
                'value' => array( "$y-$m-01", "$y-$m-31" ),
                'compare' => 'BETWEEN',
            );

            */

            $wp_query->set( 'meta_query', $meta_query );
            $wp_query->set( 'm', null );
        }
    }
}

add_action( 'pre_get_posts', 'wpse_189824_date_meta_query' );

I’ve given two options (LIKE or DATE), you might want to test and see which gives the best performance.

Related Posts:

  1. Adding a drag and drop re-ordering from a custom post type default list [closed]
  2. Filter for “get_post_type_archive_link()”
  3. Adding posts of custom type into the main feed
  4. Remove “Get Shortlink” button in admin of custom post type
  5. Custom query to filter posts that have current post as a taxonomy [closed]
  6. Why is conditionally loading a custom plugin’s code only on a specific custom post type causing the site content to disappear?
  7. creat filter with wp_query
  8. Filter Posts from the Main Query
  9. How can I add a filter to a particular post format?
  10. Is there any way to get list of all possible filter hooks for all post types?
  11. sortable columns for multiple custom post types not working
  12. Catch and display error on save_post action
  13. Query filter by value in meta_value array
  14. Best way to fix bad count on All | Mine | Published
  15. Store a value in global scope after init hook is fired
  16. Dynamic page for nav items used as filters
  17. Adding Information To All Posts Screen
  18. Filter Content on all Post Types
  19. Hook only specific post type
  20. Change CPT Edit Target Link for Admin List
  21. Hook for post and page load
  22. How do you use a CPT as the default home page?
  23. Custom sortable columns ordered by meta-value?
  24. Unregister post type from child theme
  25. Why get_next_post_link() or get_previous_post_link() doesn’t return the required links?
  26. How often do you need to register_post_type?
  27. How to set a custom post type post as static front page?
  28. With what hook can I address all posts from all custom post types when they are published?
  29. SQL to update custom post taxonomies
  30. Query multiple taxonomy in Custom Post Type
  31. Hook when adding or editing a specific custom post type? [closed]
  32. wp_query and comment_parent – select only posts with top level comments
  33. Comparing timestamps in meta query doesn’t work
  34. Display two post types ordered by two custom fields
  35. Include both default and Custom Post Type in query modified inside pre_get_posts
  36. $wpdb returns no results with SELECT query on custom post type, works on default post type
  37. Custom Post Types, Page Templates and Pagination. Why do I get a 404 Error?
  38. Add information above a custom post type listing of all posts page
  39. How can I add a column in the wp_list_table of the admin area?
  40. How to filter the description of a custom post type
  41. Automatically adding meta data to posts or multiple query help
  42. Filter home_url for custom post type
  43. Add Content Exclusively to a Custom Post Type Feed
  44. Conditional to modify query results
  45. Can’t unregister parent theme’s CPT from my child theme
  46. Ignore sticky posts if post is not in meta query
  47. How to query custom post types posts filtered by multiple custom taxonomies through a form selection
  48. How to: Display ACF [fields] on Custom Post Types Utilising WordPress ‘Hooks’? [closed]
  49. How to Filter custom post type by taxonomy?
  50. Filter hierarchical custom post type admin page by parent, and include children & grandchildren
  51. Versioned Custom Post Type (Not the same as revisions)
  52. the_content filter on some post types only not working
  53. What’s the equivalent of Hide From Menus on MODX on WordPress?
  54. Custom filter function not working with Custom post type
  55. Categorise Custom Post Types
  56. Add a custom text to admin footer in a Custom Post Type page
  57. wordpress remove views from action links in a custom post
  58. Query of custom post types only shows first post
  59. Query Custom Post Types with checkboxes
  60. List of child custom post types lists all custom post types
  61. I need to add a filter to prepend the term ‘National – ‘ to the post title if the post is tagged to multiple states
  62. How to build a WordPress post review system beside commenting
  63. WordPress hook after post content and meta update
  64. Returning a custom content types with meta values
  65. Custom Post Type not showing in main loop
  66. Problem with Apply Filters on URL in meta box filed of custom port type
  67. Shortcode to return single custom post based on post taxonomy
  68. Make a custom column sortable by a value from a different custom post type
  69. wordpress post_where set only for my costum post type
  70. Change Custom Post Type singular_name through function/filter
  71. Query Custom Post by taxonomy multiple categories
  72. Custom Post type showing up in loop, regular posts are not showing up
  73. show most viewed posts of last days by link?
  74. Display custom post front end filter by ACF equals current user
  75. Check that a slug is present in the get_terms request
  76. wp_set_object_terms creates taxonomies but does not add custom posts to it
  77. Custom Post Type action on post update
  78. Show Post Types customized in Template Page
  79. Filter in Custom post type to find the parent post
  80. Update main post with same category when creating custom post to update the modified date
  81. WP_Query for custom taxonomies showing posts from non-specified terms?
  82. WP_Query with all posts in one custom post type and only posts in another custom post type with a specific category
  83. Add content to wordpress edit.php page
  84. pricefilter without WooCommerce
  85. How can I group by Taxonomy on Custom Post Type while filtering out based on custom Meta
  86. filter rest api post by a acf filed
  87. Grouping and paging CPT events by month with custom field date
  88. Highlight a Post on archive page if it has a new comment?
  89. Execute code only after user clicks ‘update’ button for CPT being edited
  90. Custom post type with Filter and Page Nav
  91. Converting a checkbox filter for custom fields to a dropdown
  92. How do I get a nested query to only display content that the main query outputed
  93. Diffrent search templates for different post types
  94. Post content stays the same but permalink changes ?
  95. Pagination not working with custom loop
  96. custom post-type query just returns two posts
  97. Order custom post type is beign ignored
  98. How do I filter a custom post type loop by a field?
  99. A to Z list for custom post types
  100. Trying to set up a range filter for related custom post types