Pipeline - clear date field?

Question

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

markshnier__you · Answer

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

markshnier__you · Answer

https://help.quickbase.com/pipelines/transforming_data.html?Highlight=CLEAR#Clear_a_field_in_an_Update_pipe------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

jimharrison · Answer

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 Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------

markshnier__you · Answer

sorry I believe this is the syntax
{{ CLEAR }} with CLEAR in upper case.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

jimharrison · Answer

That is correct and functional.&nbsp;I also pinged QB Support.Use {{CLEAR}} to empty the contents of a date type field in a pipeline recipe step.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------

Forum Discussion

Pipeline - clear date field?

10 Replies