Time changes date

[Boris_Ling]

I would like to replace the date in the field “date” by date +5 days as soon as it is today.

what I have tried so far:
My first formula [Called: Formular1]:

IF(IS_SAME(date,NOW(),'MINUTE'), "Now")

The Second Formular [Called: RepeatCalculation]

DATEADD(date, 5, 'week')

Next, I attempted to set up an automation:
Trigger: “When a record matches conditions” when Formula1 is “Now”
Action: “Update record” Record ID “date”
When chosing Field i can not select my [RepeatCalculation]Formula.

• The following error message appears
  

I think I have missed something. I am grateful for any help.
Sorry: English is not my mother tongue

[TheTimeSavingCo · Accepted solution]

Hi Boris, I’m not too sure why that’s happening. I’ve set up a base here with the automation you’re trying to do and it seems to work fine. Perhaps you can compare the two to see what the differences are

[Boris_Ling]

Hi Adam, Thank you very much for taking the time to look into my question. The example you created helped me a lot. I have made a mistake with the RecordID. Thanks much for sharing your insight.