Dynamically change filter in Get Pending Access requests

[Nadim (Nadim El Khoury)]

Hello,
I am trying to create a workflow and in that workflow I use the “Get Pending Access Requests” action. On this action we have the possibility to filter results.

What I am trying to do is get pending requests that haven’t been modified for exactly 7 days prior to when the workflow runs. If we take today (22 august ) as an example the filter I would put would be filters = modified lt 2023-08-16 and modified gt 2023-08-14.

The behavior I want is for the filter dates to change, so I can have the pending requests that haven’t been modified for 7 days each time. what I have in mind is something like filters = modified lt now-6d and modified gt now-8d. is there a way to have a filter like that?

If not what can I intergrate in my workflow to have new dates each time that I will use in my filter

Thank you in advance

[colin_mckibben]

You can use the $.now() function in a Define Variable operator to get the current time when the workflow runs. You can then reference that variable in your filter. Check out this post for more information on using $.now().

getDay in Workflow

Hi Aditi. $.now() produces a timestamp in the following format: yyyy-mm-ddThh:mm:ssZ. An actual value will look like this: 2023-08-22T19:28:38.698Z. You can get the current day of the month by using the substring operator in your define variable step. Set the “Starts From” value to 8, and the “Length” to 2. [image] That will produce a variable that will just have the day of the month. So for a date of 2023-08-22T19:28:38.698Z, the variable will produce the value 22.