Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

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 called Today with formula today(), and use that in my condition?

Similarly, is there a way to set a field to [Date Field] + days(1) or do I have to make a field in my table and use it?

------------------------------
Mike Tamoush
------------------------------
    • UrsulaLlaveria's avatar
      UrsulaLlaveria
      Qrew Assistant Captain
      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's avatar
        MichaelTamoush
        Qrew Captain
        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
        ------------------------------