Forum Discussion

Qrew Captain

Re: Pipelines - Condition Date before today

If someone stumbles on this post, the answer is here:

https://help.quickbase.com/pipelines/working_w_date_time.html

------------------------------
Mike Tamoush
------------------------------

3 Replies

UrsulaLlaveria
Qrew Assistant Captain
5 years ago
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
------------------------------
- MichaelTamoush
  Qrew Captain
  5 years ago
  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
  ------------------------------
  - UrsulaLlaveria
    Qrew Assistant Captain
    5 years ago
    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
    ------------------------------