Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Pipeline help

This is somewhat related to my last post, but more seems to be a bug so I thought I would start a new thread.

If I search for records where [Date Field] is before a certain date (if I pick a specific date from the calendar), the search yields records.

If I try to search where [Date Field] is before today(), there seems to be no way I can get this to work. I have tried using a formula date field called [Today] and use that for the before condition. I tried actually typing today() right in the condition line. Nothing seems to work.

Does anyone know how to use todays date as part of a condition in pipelines?

------------------------------
Mike Tamoush
------------------------------
  • If you are just looking for a solution and not looking to learn Jinja, you can create a checkbox formula field in Quick Base and filter on that is  "yes".

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      Thats a good low code solution. I also discovered I could use [Date] is before: {{time.today}}



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