Unselected Records returning Null for field

Question

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

kenbuja · Answer

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
);

kenbuja · Answer

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;

JeffreyHinderliter · Answer

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