Date & Min function to create a new field in script

[Taylorcc]

Hello

Is there a way i can use this logic to create a new field in the script? 

Date(Min([service_contact_date],episode_key)) as Referral_Commenced_Date

I want to use the first service contact date of each epsiode as their referral commenced date.. 

Thank you 

[Kushal_Chawda]

try below

Data:
load [service_contact_date],
episode_key,
.....
FROM Source ;

left join(Data)
load episode_key,
Date(Min([service_contact_date])) as Referral_Commenced_Date
Resident Data
group by episode_key;