CAllSQLWhere::addDateFilter

public function addDateFilter(&$result, $isMultiple, $FIELD_NAME, $operation, $value, $format)
{
	global $DB;

	if (is_array($value))
	{
		$FIELD_VALUE = array();
		foreach ($value as $val)
		{
			if ($val instanceof BitrixMainTypeDate)
			{
				$FIELD_VALUE[] = $DB->CharToDateFunction((string)$val, $format);
			}
			elseif (is_object($val))
			{
				$FIELD_VALUE[] = $val->compile();
			}
			elseif($val <> '')
			{
				$FIELD_VALUE[] = $DB->CharToDateFunction($val, $format);
			}
			else
			{
				$FIELD_VALUE[] = 'NULL';
			}
		}
	}
	elseif ($value instanceof BitrixMainTypeDate)
	{
		$FIELD_VALUE = $DB->CharToDateFunction((string)$value, $format);
	}
	elseif (is_object($value))
	{
		$FIELD_VALUE = $value->compile();
	}
	elseif($value <> '')
	{
		$FIELD_VALUE = $DB->CharToDateFunction($value, $format);
	}
	else
	{
		$FIELD_VALUE = 'NULL';
	}

	switch($operation)
	{
	case "I":
	case "E":
	case "S":
	case "M":
		if (is_array($FIELD_VALUE))
		{
			$result[] = $FIELD_NAME." in (".implode(", ", $FIELD_VALUE).")";
			if ($isMultiple)
				$this->bDistinctReqired = true;
		}
		elseif ($value == '')
			$result[] = "(".$FIELD_NAME." IS NULL)";
		else
			$result[] = $FIELD_NAME." = ".$FIELD_VALUE;
		break;
	case "NI":
	case "N":
	case "NS":
	case "NM":
		if (is_array($FIELD_VALUE))
			$result[] = $FIELD_NAME." not in (".implode(", ", $FIELD_VALUE).")";
		elseif ($value == '')
			$result[] = "(".$FIELD_NAME." IS NOT NULL)";
		else
			$result[] = $FIELD_NAME." <> ".$FIELD_VALUE;

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "G":
		if (is_array($FIELD_VALUE))
			$result[] = $FIELD_NAME." > ".$FIELD_VALUE[0];
		else
			$result[] = $FIELD_NAME." > ".$FIELD_VALUE;

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "L":
		if (is_array($FIELD_VALUE))
			$result[] = $FIELD_NAME." < ".$FIELD_VALUE[0];
		else
			$result[] = $FIELD_NAME." < ".$FIELD_VALUE;

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "GE":
		if (is_array($FIELD_VALUE))
			$result[] = $FIELD_NAME." >= ".$FIELD_VALUE[0];
		else
			$result[] = $FIELD_NAME." >= ".$FIELD_VALUE;

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "LE":
		if (is_array($FIELD_VALUE))
			$result[] = $FIELD_NAME." <= ".$FIELD_VALUE[0];
		else
			$result[] = $FIELD_NAME." <= ".$FIELD_VALUE;

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "B":
		if (is_array($FIELD_VALUE) && count($FIELD_VALUE) > 1)
			$result[] = $FIELD_NAME." between ".$FIELD_VALUE[0]." AND ".$FIELD_VALUE[1];

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "NB":
		if (is_array($FIELD_VALUE) && count($FIELD_VALUE) > 1)
			$result[] = $FIELD_NAME." not between ".$FIELD_VALUE[0]." AND ".$FIELD_VALUE[1];

		if ($isMultiple)
			$this->bDistinctReqired = true;
		break;
	case "IN":
		$result[] = $FIELD_NAME." IN (".$FIELD_VALUE->compile().")";
		break;
	}
}