Delete a record by automation

[Martin_Leber]

Hi. I need to have a calendar overview showing two fields - a delivery date field and a publishing date field. What i am trying to figure out is, how am i able to delete the delivery date field entry, so whenever the date is the exact date of delivery i am trying to delete the delivery date field entry, so in my calendar the delivery date is not shown anymore - but the publishing date is still visible.

Thanks in advance
Martin

[Vivid-Squid · Accepted solution]

Hi @Martin_Leber,
HMMM, that is unique.
Maybe create a formula that compares the dates and gives you a boolean result. Then use this result to update the delivery date to blank as needed.

IF({Delivery Date}={Publishing Date}, 'same', 'different')