Skip to main content
Solved

Delete date field entries by Automations

  • September 8, 2022
  • 1 reply
  • 8 views

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

Best answer by Vivid-Squid

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



View original
Did this topic help you find an answer to your question?

1 reply

  • Inspiring
  • 532 replies
  • Answer
  • September 8, 2022

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




Reply