Skip to content



Bases: BaseSchemaAction

Create a new field by iterating over a list of fields and selecting the oldest value in the list.

Script template

"SELECT_OLDEST > 'destination_field' < ['source_field' + 'source_field_date', 'source_field' + 'source_field_date', etc.]"

Where + links two columns together, explicitly declaring that the date in source_field_date is used to assign the order to the values in source_field. Unlike the SELECT action, SELECT_OLDEST takes its ordering from this date assignment.


"SELECT_OLDEST > 'occupation_state_date' < ['Current Relief Award Start Date' + 'Current Relief Award Start Date', 'Account Start date' + 'Account Start date']"