Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago

Pipeline - clear date field?

Is there a way to clear the value of a date field in a pipeline?  I have am replacing my automations with pipelines and I have a couple automations that will clear a date field given a certain condition.  I tried using a null field I have in the table and leaving the value empty in the pipeline step.  Neither of those worked.

------------------------------
Paul Peterson
------------------------------
Pipelines
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Try this

    "CLEAR"


    just like that in Quotes. I never tried it myself but my cheat notes said that's the way to do it. Please post back and confirm that it worked for you.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JimHarrison's avatar
      JimHarrison
      Qrew Champion
      4 years ago

      Validation error: Invalid date/time value: "CLEAR"

      Input (Mapping)
      start_date:""CLEAR""

      Also tried "" and same error. I'll update when I find the solution.


      ------------------------------
      Jim Harrison
      transparency = knowledge + understanding : The Scrum Dudes
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        sorry I believe this is the syntax

        {{ CLEAR }}

        with CLEAR in upper case.



        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------