How to order custom user list columns by datetime?

I think you could simplify this a lot by using the pre_get_users hook, instead of working directly with the complicated SQL within the pre_user_query hook.

Try something like:

add_action( 'pre_get_users', function( \WP_User_Query $q )
{
    $qv = &$q->query_vars;
    if( isset( $qv['orderby'] ) && 'test_date' === $qv['orderby'] )
    {
        // Custom meta query
        $qv['meta_query'] = [
            'custom' => [
                'key'   => 'test_date',
                'type'  => 'DATETIME'
            ]
        ];

        // Order by the 'custom' meta query
        $qv['orderby'] = 'custom';

    }
} );

where we’ve added the extra 'custom' key in the meta query, so that we can order by it as well. This would assume all users to have the test_date user meta key.

Hope you can adjust this accordingly.

Related Posts:

  1. Woocommerce Pre Orders view order link wrong [closed]
  2. Sort on meta value but include posts that don’t have one
  3. Using Orderby and meta_value_num to order numbers first then strings
  4. multiple orderby in pre_get_posts action
  5. get_the_terms in descending alphabetical order
  6. Ordering posts having multiple post-meta date fields
  7. next and previous post link ordered alphabetically
  8. Order posts by meta_value even if meta_key is not filled
  9. Order by first name
  10. Query between two meta values?
  11. How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?
  12. the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
  13. List taxonomy terms plus their latest post ordered by post date
  14. Sorting Attributes order when using get_the_terms
  15. How to order posts by meta value?
  16. How Do I Order Posts by Modified Date? [duplicate]
  17. Orderby Post Views
  18. How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
  19. How to order posts by alphabet with numbers at the end
  20. List of posts by day of the week
  21. WP User Query get all authors with last name starting with specific letter
  22. Best Plugin to Reorder Post Types
  23. Ordering system through WordPress
  24. Issue with multiple orderby values
  25. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  26. get_query_var returns wrong default value
  27. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  28. Use pre_get_posts to sort meta_key by an array of values
  29. Show first the posts from 1 specific tag
  30. Order posts by price
  31. All, published and pending order
  32. Order by summing multiple values
  33. get_adjacent_post() returning weird results
  34. Get_Users Orderby Page
  35. Sort order of next/prev sibling page
  36. Order char by post title
  37. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  38. next_post_link and previous_post_link order not working properly
  39. query pages by a childs publish date
  40. List most recently added posts (with a twist)
  41. Check post_date in pre_get_posts
  42. Debugging wp_query orderby for taxonomy
  43. How can I prevent certain custom roles from seeing other custom roles on the user list page?
  44. pre_get_posts shows posts in random order sometimes
  45. Featured-Content/Featured Posts With Random Order
  46. Orderby in Query Posts affected by operating system?
  47. Ordering posts by title containing numbers
  48. last_name + first_name orderby with meta_query [solved]
  49. Stylesheet Enqueue Order and Best Practices
  50. wp_list_pages sort order by top nav menu order and child of
  51. How to display taxonomy terms the way they are hierarchical
  52. wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
  53. WP_User_Query orderby meta_val_num
  54. How to add a date creation field when a custom taxonomy relationship is created?
  55. Randomly select one of last 3 posts
  56. Order by ASC, DESC, Title, Date from URL on custom page template post
  57. Offset posts with random order
  58. view subcategories order by id
  59. Sort query output on taxonomy term archive by post type using pre_get_posts
  60. ASC and DESC separately from orderby
  61. Order WP_Query by The Order of an Array in Tax_Query
  62. struggling to order by title
  63. Order by two meta values – one is a number and the other is text
  64. Last post sorting get_categories
  65. Compare time value in WP_User_Query for sending emails
  66. Sort by DESC works, ASC doesn’t?
  67. SQL to set Display Name to First Name + Last Name
  68. Shop sends Mail with order cancellation
  69. List of terms in alphabetical order under the respective initial letter and within columns
  70. update_post_meta saves data but does not show in Order backend
  71. sort title descending with title with number
  72. Changing cache update rate
  73. WP_User_Query Orderby Not Working
  74. how to complete order status automatically after paypal payment received
  75. Order management including recurring orders on woocommerce
  76. Orderby Title not working
  77. Sort loop by title doesn’t sort single digits like human would
  78. Woocommerce order_complete email dont send after changing order status via sql
  79. Sort posts by meta value with get method
  80. Why Am I getting an error when I add the number parameter to my WP_User_Query?
  81. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  82. Custom post order when using OR relation
  83. Creating a post that contains a list of other posts like a table of contents
  84. Want to order by Meta Values (tweaking Post Order Widget)
  85. Changing posts order on a page
  86. How to order posts by the user_login that corresponds to a meta_value (which is a user id)?
  87. Pre_Get_Posts order DESC not registering
  88. orderby in WP_query doesn’t works
  89. Ordering Subcategories
  90. Sort users by custom user meta value
  91. How to order posts by parents?
  92. single post navigation order (NOT chronological)
  93. WP_Query with several meta_query-statements and order by meta_value
  94. Woocommerce: Grab total revenue of a product over all orders
  95. Problem with meta_value order after update
  96. Random order of posts on each request
  97. How can I make have_posts() return posts ordered DESC by id?
  98. Add post order like page order
  99. How to make WordPress orderby work with post_excerpt column?
  100. Orderby with menu_order and title
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)