I want to only have it pull a specific relationship (Part AML) if a custom date field "Valid To" is greater than the current date. I am able to create the Where that compares it against a specific date, but this query definition is pulled by another process automatically and I don't want to have to update the Query Definition every day with the current date for whoever ends up running it that day.
I currently have:
[Valid to] > '2021-11-29T00:00:00'
I want something like (this doesn't work)
[Valid to] > current_date()