If you want to set up a dynamic date filter that loads only rows from the current month:
At the moment, we don't have a built-in option to use date placeholders for a Date Range filter like this, but there is a custom workaround if you use an SQL query-based table.
Here’s an example of an SQL query that dynamically filters dates for the current month and year:
SELECT * FROM table_name
WHERE date_column >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
AND date_column < DATE_FORMAT(CURDATE() + INTERVAL 1 MONTH, '%Y-%m-01');
Of course, please change the table_name to your actual SQL table name and date_column to your column name which stores the date values.
Here is the explanation of the logic for this WHERE statement.
DATE_FORMAT(CURDATE(), '%Y-%m-01') → Gets the first day of the current month.
DATE_FORMAT(CURDATE() + INTERVAL 1 MONTH, '%Y-%m-01') → Gets the first day of the next month, ensuring only dates from the current month are selected.
The WHERE clause ensures that only rows within the current month are loaded.
This query dynamically updates every month without needing manual adjustments.