Steps to reproduce the issue

Create some sample articles
Create a new instance of mod_articles_category
Set filter for date to relative

Expected result

Get all articles x days in the past till now

Actual result

$items returns false and this leads into the follwing error in the frontend:

Warning: Invalid argument supplied for foreach() in /Users/marcorensch/Sites/joomla4b5/components/com_content/src/Model/ArticlesModel.php on line 713

Warning: Invalid argument supplied for foreach() in /Users/marcorensch/Sites/joomla4b5/modules/mod_articles_category/src/Helper/ArticlesCategoryHelper.php on line 257

System information (as much as possible)

Joomla 4 Beta 6
MAMP local
PHP 7.4.12
MySQL 5.7.32

Additional comments

I've found this issue while checking the code for a module (because mine worked either) and even if all looks good (and similar to J3 its not working in J4 when doing this in the model:

case 'relative':
				$relativeDate = (int) $this->getState('filter.relative_date', 0);
				$query->where(
					$db->quoteName($dateField) . ' IS NOT NULL AND '
					. $db->quoteName($dateField) . ' >= ' . $query->dateAdd($nowDate, -1 * $relativeDate, 'DAY')
				);
				break;

ArticlesModel.php line 571 and below.
the $nowDate has to be 'quoted' in J4:
It should look like:

case 'relative':
				$relativeDate = (int) $this->getState('filter.relative_date', 0);
				$query->where(
					$db->quoteName($dateField) . ' IS NOT NULL AND '
					. $db->quoteName($dateField) . ' >= ' . $query->dateAdd($db->quote($nowDate), -1 * $relativeDate, 'DAY')
				);
				break;

When i change it its working on my installation.
Did someone else expecting the same error?