Advanced filter on DCL with end date as input

Summary:

In Advanced filter, I will like to filter as shown below:

PartySiteUse.EndDate<=:CurrentDate

Where CurrentDate = def currentDateTime = now();
return currentDateTime;

Issue: Unable to use above condition.

Content (please ensure you mask any confidential information):

On Opty > Created a DCL to only show active BILL_To addresses, To restrict end-dated address types, I'm trying to include additional filter

Version (include the version you are using, if applicable):

24D

Code Snippet (add any code snippets that support your topic, if applicable):