Does anyone have a tip or has done a workflow trigger that will kick off if an account from a certain source has an end date of 30 + days and is inactive to fire off? I have never done this with a date and have not seen anyone yet try this as well for a workflow trigger
I rather not add another attribute on a profile if I do not have too
$.topping[?(@.startDate >= “2024-07-01”)].id → This query will only return 5001. However, there is no difference computation as such to check more than 30 days or so. Json path can be helpful for date comparison against two date variables or with a static date.
In my opinion, best approach here would be to create an Identity Attribute that will change when end date is in 30 days (you can do it with dateCompare), and trigger the workflow on Identity Attribute change.
You could try using the schedule trigger to run a workflow every day. The workflow will start by using a search query to query all identities with an end date attribute that is 30 days out, and that is inactive. This would give you a list of identities that you can process further.