Filter X date is 10 days before Y date

Ken166
Mega Contributor

I'm trying to make a filter that will show all worker provisioning requests created that have a hire date less than 10 days before it was submitted to locate short notice worker provisioning requests.

 

This is the filter I have so far:

Ken166_0-1682012326042.png

 

My problem is locating the "Choose Field" value.

 

Ken166_1-1682012400307.png

 

There is clearly a child of the worker provisioning, an REQ, that is created and has a created date that I could theoretically use, but I can't seem to find it by navigating through this filter tree.

 

Ken166_2-1682012680972.png

 

Is there a way to compare a hire date of a work provisioning to the created date of the request?

0 REPLIES 0