_number oldpolicy   from date   to date   status

   213      -        01/01/2018   12/31/2018   lost

_number oldpolicy   from date   to date     status

   1234      1d23    01/01/2018   04/31/2019   lost

_number oldpolicy   from date   to date     status

   abc    abc134      01/01/2018   05/31/2019   renew
   324     abc        05/31/2019   12/31/2019    renew

_number oldpolicy   from date   to date     status

   324    -             02/31/2019   12/31/2019    new

if(Len([Parent Policy])=0 and UW_YEAR=Year(Today()) , 'new',
if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew')
)