@Helena If that works for you, then do that. Otherwise create two Date filters instead (start and end), which you can use more flexible. You cannot control Field Filters in the way you want.
You can create a central table like @flamber suggested in the first post.
For example, create a table called a calendar which will have dates from 01-01-1970 to 01-01-2100 which you can join with the original tables in both of your queries.
In the where clause you can use the filter from the calendar table and use it as a field filter.