This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Reply To: Search FROM DATE including the date

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Search FROM DATE including the date Reply To: Search FROM DATE including the date

#22326
Ernest MarcinkoErnest Marcinko
Keymaster

Hi,

I think this might be related to exact dates without times, maybe try this variation:

                // Is this a special case of date operator?
                if (strpos($operator, "datetime") === 0) {
                    switch ($operator) {
                        case 'datetime =':
                            $current_part = "($wpdb->postmeta.meta_value BETWEEN '$posted 00:00:00' AND '$posted 23:59:59')";
                            break;
                        case 'datetime <>':
                            $current_part = "($wpdb->postmeta.meta_value NOT BETWEEN '$posted 00:00:00' AND '$posted 23:59:59')";
                            break;
                        case 'datetime <':
                            $current_part = "($wpdb->postmeta.meta_value <= '$posted 23:59:59')";
                            break;
                        case 'datetime >':
                            $current_part = "($wpdb->postmeta.meta_value >= '$posted 00:00:00')";
                            break;
                        default:
                            $current_part = "($wpdb->postmeta.meta_value < '$posted 23:59:59')";
                            break;
                    }
                    // Is this a special case of timestamp?
                } else if (strpos($operator, "timestamp") === 0) {
                    switch ($operator) {
                        case 'timestamp =':
                            $current_part = "($wpdb->postmeta.meta_value BETWEEN $posted AND ".($posted + 86399).")";
                            break;
                        case 'timestamp <>':
                            $current_part = "($wpdb->postmeta.meta_value NOT BETWEEN $posted AND ".($posted + 86399).")";
                            break;
                        case 'timestamp <':
                            $current_part = "($wpdb->postmeta.meta_value <= ".($posted + 86399).")";
                            break;
                        case 'timestamp >':
                            $current_part = "($wpdb->postmeta.meta_value >= ".($posted).")";
                            break;
                        default:
                            $current_part = "($wpdb->postmeta.meta_value < $posted)";
                            break;
                    }
                    // Check BETWEEN first -> range slider
                } else if ( $operator === "BETWEEN" ) {