I am trying to query a custom post type that has a meta value (DATE) that are equal or greater than today. My issue is that some posts have the date stored in the "Ymd" format and others have "Y-m-dTg:i a".
This is what I currently have. It currently isn't ordering properly.
'posts_per_page' => -1, 'orderby' => 'meta_value_num', 'order' => 'ASC', 'post_type' => 'funeral', 'post_status' => 'publish', 'meta_query' => array( array( 'relation' => 'OR', array( 'key' => 'service_date', 'value' => date('Ymd'), 'compare' => '>=', 'type' => 'DATE' ), array( 'key' => 'service_date', 'value' => date('Y-m-dTg:i a'), 'compare' => '>=', 'type' => 'DATE' ) ) )