I am working in a document library. I have a field, SessionType, that is a managed metadata field which can contain either a value of "Upcoming" or a value of "Past session". In addition, each item in the library has an EventDate and EndDate.
I'd like to make a workflow that changes the value of the SessionType from "Upcoming" to "Past session" when the current date/time is greater than the EndDate.
I'm not sure how best to write this workflow. Should it be a timer job? If so, how would I write that?