Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Pipeline - clear date field?

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
------------------------------

9 Replies

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
  Qrew Legend
  4 years ago
  sorry I believe this is the syntax
  
  {{ CLEAR }}
  
  with CLEAR in upper case.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    https://help.quickbase.com/pipelines/transforming_data.html?Highlight=CLEAR#Clear_a_field_in_an_Update_pipe
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------