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
April 26, 2019 at 7:37 am
#22326
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" ) {