Jinja Expression for Duration (Days) > 100
Working a seeming simple pipeline to search casework, where [case age] is greater than 100 days. [case age] is a duration between two dates expressed in Days.
In the pipeline, when querying the ...
Forum Discussion
Is your duration set to always be in days? If so, I would create a new formula numeric field: [Duration as Number].
Though it might seem like ToNumber([Case Age]) should work, I believe that will give you an error. I believe you need to use: ToDays([Case Age]). Then use that new formula numeric field in your query.
I am sure there is a also a fancy way to do it in Pipelines with an Advanced Query written in Jinja, but that is over my head!
------------------------------
Mike Tamoush
------------------------------