This automation can be configured directly from the board's Automation section. Follow the steps below to complete the setup and ensure the automation runs as expected:

  1. Open the board that contains your courses

  2. Add a new date column for the expiration date

  3. Open the Automations dashboard and click on Create automation

  4. Choose the trigger "When status changes to something"

  5. Select the Status column and choose Published

  6. Add the action "Set date"

  7. Click on date column to select the Expiration date column 
  8. Click on date to select today

  9. Add the action "Push date"

  10. Click on date to select the Expiration date column 
  11. Click on some time to set the expiration date

  12. Create the automation

Example: