Unselected Records returning Null for field

[JeffreyHinderliter]

if ($record.size != null && $record.material != null && $record.verifdate ==null)  

$record.survey_date

The above expression is used within a calculate field parameter.  My test data set has 16 records where all 16 records have the size and material populated.  6 of the 16 records have a verifdate populated so they are not null.  The expression is looking for records where size and material is populated but the verifdate is not populated so the date can be updated from a joined S123 table.

When I run or preview the DP, the calculate does populate the date for the 10 fields where verfidate is null, but it is changing the 6 fields with existing dates to Null.  Those 6 fields are not in the selection criteria.  

Thoughts? Thanks

[AustinAverill]

From what you have copied and pasted, it appears your syntax for Arcade isn't correct... At a minimum you need to add curly brackets after your condition and then add a `return` so that the value is returned. The code as you pasted it would not return a value.

if ($record.size != null && $record.material != null && $record.verifdate ==null){
    return $record.survey_date
}

[JeffreyHinderliter]

It does return a value, although not entirely correct. I will try what you suggested. Thanks!

[JeffreyHinderliter]

Austin, made that change but still have the same results.  

[KenBuja]

You need the return, but when the if statement only has one line, you don't need brackets. This would work perfectly fine

if ($record.size != null && $record.material != null && $record.verifdate == null) return $record.survey_date;

[KenBuja]

For the records where verifdat is populated, do you just want to keep that date? Give this a try

When(
  $record.size != null && $record.material != null && $record.verifdate == null, $record.survey_date, 
  $record.verifdate
);