Automation to copy line but modify effective date

Hi Has anyone created any automation that will create a duplicate item with new dates once a status has been met? I’m attempting to automatically create items that represent renewals of sales for sales tracking for items that renew in 6 or 12 months.

hi @MarkHo

Welcome to the community! To set the date to “today” (the date the status changes) you can use this custom automation:

If you need to set the date to something else you might want to use the app “Set Relative Timeline” (which also sets dates) and use this automation: