WP_User_Query Custom Field meta_query with Date clause

You can set the type of the data in your meta_query.

Unfortunately, you can only use the comparison BETWEEN if your date is in the format YYYYMMDD. So to see the users for one year, you would have to set your metaquery like this:

$usersByCompanyArgs = new WP_User_Query(
    array(
        'fields' => 'all_with_meta',
        'orderby' => 'bhaa_runner_dateofrenewal',
        'order' => 'DESC',
        'meta_query' => array(
            array(
                'key' => 'bhaa_runner_company',
                'value' => $this->houseid,
                'compare' => '='),
            array(
                'key' => 'bhaa_runner_dateofrenewal',
                'value' => '2014-01-01', // date to compare to, before this one
                'compare' => '<',
                'type' => 'DATE' //set the format
            ),
            array(
                'key' => 'bhaa_runner_dateofrenewal',
                'value' => '2013-01-01', // date to compare to, after this one
                'compare' => '>=',
                'type' => 'DATE' //set the format
            ),
        )
    )
);

If your Date field was formated YYYYMMDD you could replace the two comparisons in the meta_query with

            array(
                'key' => 'bhaa_runner_dateofrenewal',
                'value' => array( '20130101', '20140101' ), // date to compare to, after this one
                'compare' => 'BETWEEN',
                'type' => 'DATE' //set the format
            )

Related Posts:

  1. WP_User_Query to exclude users with no posts
  2. WP_User_Query will not combine meta + normal search methods
  3. WP_User_Query users by registered date
  4. User appears twice in a WP_User_Query
  5. Want to add my custom prepare query but add_filter doesn’t run
  6. each_connected in wp_user_query with Scribu’s Posts to Posts Plugin – Alternative method? [closed]
  7. Sort WP_User_Query by meta_key value with pre_user_query
  8. Ordering WP_User_Query results by the user IDs used in the include parameter
  9. Get users in query and limit user output to five in random order
  10. Echo the number of users using WP_User_Query?
  11. Query Users by login, meta & role
  12. Basic Wp_user_query not finding any users
  13. Modify user table search results
  14. WP_User_Query not displaying any user [closed]
  15. Is it necessary to escape LIKE term in WP_User_Query?
  16. Exclude Users of a Certain Role in the Users Page
  17. Save users last visited blogs within whole network
  18. Snippett for create field in registration for users
  19. WordPress WP_User_Query($args) using Where and Like
  20. WP_User_Query unexpected output after upgrading toWordPress 4.0.1
  21. WP_User_Query Filter Results
  22. custom post type ‘pre_[cpt]_query’ hook
  23. Can you return users of a higher role than the current user using get_users()?
  24. WP_User_Query with 2 sets of conditions ‘AND’
  25. unable to modify user table search results based on meta key
  26. Problem with WP_User_Query when ‘meta_value’ is an array
  27. Wp_user_query search by meta_key not returning any results
  28. WP_User_Query is Not Displaying Results
  29. How to display pagination links for WP_User_Query?
  30. List users by last name in WP_User_Query
  31. How to order WP_User_Query results to match the order of an array of user IDs?
  32. Searching users with WP_List_Table plugin
  33. WP_User_Query with combined meta query – not working?
  34. How to add custom query filters in WP_User_Query
  35. Check if WP_User_Query ‘include’ is empty
  36. Searching user meta using WP_User_Query
  37. WP CLI – show users whose ID is larger than given ID
  38. How to display next and prev pagination links with WP_User_Query?
  39. Users instead of posts: How to modify the main query?
  40. How to use search_columns in WP_User_Query?
  41. How to query users who have empty first_name?
  42. WP User Query fails when searching meta queries and search columns
  43. Query users by capability – uninstall/deactivate callback
  44. Get users between user ids
  45. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  46. WP_User_Query pulling ACF to loop
  47. WordPress search posts by author name with autocomplete
  48. Four columns in the wp_users table
  49. how to know when the user is in specific part of the website and when he leaves that part and display the data in the admin dashboard
  50. pagination with numbers for WP_User_Query
  51. Why get_users() not working on the admin backend?
  52. WP_User_Query – searching multiple fields
  53. Is there a maximum limit of the number of users returns by WP_User_Query?
  54. Passing args to WP_User_Query am I using meta correctly?
  55. WP_User_Query not returning users with meta – what am I missing?
  56. How to activate the user search
  57. Conditional IF statement not returning true even though echo of $user->province is correct
  58. Randomize Users
  59. creating new field on mysql
  60. Reduce number of SQL queries inside WP_Query loop to fetch author data
  61. last_name + first_name orderby with meta_query [solved]
  62. array of meta values using WP_User_Query
  63. meta query based on month regardless of year
  64. How to properly use AND / OR in custom search
  65. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  66. Add Watermark to PDF’s of logged in user in WordPress upon upload to media library [closed]
  67. construct complex queries with WP User Query
  68. Change users.php WP_User_Query
  69. WP_User_Query orderby meta_val_num
  70. Is it possible to use WP_USER_QUERY to search by username using a wildcard? [closed]
  71. WordPress get last inserted user id
  72. User query – getting values for custom meta keys/fields
  73. Getting current user data with MySQL statement
  74. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  75. Wrong result in fetching User meta of WordPress
  76. Query users and count totals based on meta values
  77. How to optimize the opening speed of admin panel?
  78. SQL to join u3g_users & u3g_meta_value with repeating data
  79. Getting user data via ajax
  80. Find count of WordPress users by role and search string for user name
  81. How to display replies to his comments in user profile of current user
  82. How to do WP_User_Query for Nested Array value Inside Nested Array field
  83. Get label in user meta query
  84. Create a unique username with validation on wordpress registration
  85. WP_User_Query Orderby Not Working
  86. WP_User_Query not searching numbers?
  87. WP_User_Query counter not updating with pagination
  88. Why Am I getting an error when I add the number parameter to my WP_User_Query?
  89. Get Sticky User in user loop based on user role
  90. How to order users alphabetically by name? in plugin UPME
  91. How to fetch WP_User_Query with multiple role arguments [duplicate]
  92. Display Users from two roles in one list
  93. Query Users by post count, last 30 days and display each users post count according to post type
  94. Shortcode for displaying the user’s first name?
  95. Extend user search in the Wp backend area on the users.php page to allow for searching by email domain and role from the “users search” input box
  96. Show only users with the same role in Dashboard user list
  97. WordPress WP_User_Query ignores the `meta_query` when called from an Ajax function
  98. wp_mail function not working in user query loop
  99. Query a meta key using an array of values where the database value is a string
  100. Making a user platform reachable by a qr code on a pin-back-button [closed]

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduedusedusedusedusedueduedu