Populate missing dates from features in the same feature class

GregN_WesslerEng

I have a feature class of water Mains. About half of the mains are missing the install date, and spatially the lines with missing install dates are in between two lines with dates. Can I use attribute rules to find the install dates of connecting lines and populate the install date with the older date? Or would Field Calculator be better since this needs to only apply to features where InstallDate is NULL?

RPGIS

If you only need to update the null values once then a simple calculation using arcade will do the trick. It would look something like this.

var OID = $feature.OBJECTID
var DV = $feature.<DateField>
if( IsEmpty( DV ) ){ DV = Today() }

var FS = Filter( $featureset, 'OBJECTID <> @OID' )
var I = Intersection($feature, FS)
if( Count(I) > 0 ){
	for( var row in I ){
		if( row.<DateField> < DV ){ DV = row.<DateField> }
		}
	}
return DV