0

I am trying to set a date field to Null when there is a checkbox set for a record.

I have tried using Formula field of type Date and setting it to Null, using process builder global constant and tried to set it to null, used custom labels as well but to no avail. None of the methods I have used seems to set the date field to NULL or Blank

PFA 1)Flow design

enter image description here

2)Flow node enter image description here

3)When I tried to run it in debug mode it is showing as Null enter image description here

4)When I go back to the record the date field is not blank but gets filled with any arbitrary value,however this is to also add,the moment I replace the blank or Null with a Now() or Date.today() it correctly displays todays date in the field.

P.S. this is to also add that it is a Date type field.

2
  • What does your flow look like? A screenshot could help us help you better.
    – sfdcfox
    May 8, 2022 at 17:18
  • hi @sfdcfox added the screenshots
    – Vmitra
    May 9, 2022 at 9:12

1 Answer 1

2

You don't need to use a formula field - simply leaving the value entry blank in the Assignment element will set the null. In the documentation:

If you leave a field or resource value blank, the value is null at run time

3
  • +1 though the reason I asked the question is it feels more like a "they forgot to save their changes" rather than using an incorrect input value. We'll see how it turns out.
    – sfdcfox
    May 8, 2022 at 17:48
  • Hello @sfdcfox and David I have added my comments provided s.s for the flow.Could you please have a look
    – Vmitra
    May 9, 2022 at 3:34
  • This is not a solution. I am currently using this solution and to no avail it is not working. Sep 21, 2022 at 18:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .