admin管理员组

文章数量:1310415

How I want to sort my custom column contain string date with format j F Y

my column data contains string example "21 januari 2021", how I can change the format to date so I sort it.

My value from postmeta with meta_key "datepicker".

here my code:

    add_action( 'pre_get_posts', 'manage_wp_posts_be_qe_pre_get_posts', 1 );
function manage_wp_posts_be_qe_pre_get_posts( $query ) {


   if ( $query->is_main_query() && ( $orderby = $query->get( 'orderby' ) ) ) {

      switch( $orderby ) {

     
         case 'delivery_date':

            // set our query's meta_key, which is used for custom fields
            $query->set( 'meta_key', 'datepicker' );

            $query->set( 'orderby', 'meta_value' );
            break;

      }

   }

}

how I can orderby meta_valuewith format date?

本文标签: functionsOrder column custom date using pregetposts