How to automatically change a Content type field value based on Date field?
I think you have to do this with some custom JS code.

You can do something like this:

$('.end-date-field').on('change', function () {
  var endDate = new Date($(this).val());
  if (endDate &lt; Date.now()) {
    $('.status-field').val('inactive');
  }
});


This code is not 100% correct, but it can help you to get an idea of what you have to do.