Pipelines - Condition Date before today
When searching records in pipelines, if I want to make a condition if [Date Field] is before today, is that something I can easily do in pipelines, or do I have to create a formula field in my table c...
Forum Discussion
Mike, I am having a similar issue but can't seem to get my criteria to work. I had it set to [date last reported] is after {{time.today}} but it doesn't seem to want to trigger. What am I missing?
------------------------------
Ursula
------------------------------
------------------------------
Ursula
------------------------------
I wish I could help, but unfortunately I still am struggling myself with pipelines! That sounds like it should work to me, but maybe someone else has advice?
You can start by making a field in your table, with the formula today() and comparing date last reported to that. If it works, it confirms something is wrong with that {{time.today}} syntax.
------------------------------
Mike Tamoush
------------------------------
You can start by making a field in your table, with the formula today() and comparing date last reported to that. If it works, it confirms something is wrong with that {{time.today}} syntax.
------------------------------
Mike Tamoush
------------------------------
- Funny you should mention that, it is exactly what I did, and it worked with the formula. I ended up using an advanced query, but instead of using EX. I had to use IR. :
{'51'.IR.'today'}) and this seemed to work. However, the other portion of the query, which is searching for contains "Secure VDR". Now it is getting stuck on that. Always an adventure with Pipelines haha
------------------------------
Ursula
------------------------------