That is correct and functional.
I also pinged QB Support.
Use {{CLEAR}} to empty the contents of a date type field in a pipeline recipe step.
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
Original Message:
Sent: 09-23-2021 11:10
From: Mark Shnier (YQC)
Subject: Pipeline - clear date field?
https://help.quickbase.com/pipelines/transforming_data.html?Highlight=CLEAR#Clear_a_field_in_an_Update_pipe
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 09-23-2021 11:07
From: Mark Shnier (YQC)
Subject: Pipeline - clear date field?
sorry I believe this is the syntax
{{ CLEAR }}
with CLEAR in upper case.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 09-23-2021 10:35
From: Jim Harrison
Subject: Pipeline - clear date field?
Validation error: Invalid date/time value: "CLEAR"
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
Original Message:
Sent: 09-22-2021 17:10
From: Mark Shnier (YQC)
Subject: Pipeline - clear date field?
Try this
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
Original Message:
Sent: 09-22-2021 16:14
From: Paul Peterson
Subject: 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
------------------------------