Currently, "Active Dates" fields require a specific date or date range and don’t support a relative date such as “Today.” As a result, if you want the query to return results active as of today, you need to enter the current date in the criteria before you run the query.

Often, I am creating dynamic queries to be used for constituent lists, or for other team members to run a query that I have built. In both of these scenarios I am unable to use the Active Dates features as it requires editing the criteria before using the query. Therefore, in order for this function to be valuable for us, we need relative date options.