hi i have several records like this
_number oldpolicy from date to date status 213 - 01/01/2018 12/31/2018 lost
the status is lost beacuse there is no oldpolicy number and also to date is passed so these kind of records should be lost
_number oldpolicy from date to date status 1234 1d23 01/01/2018 04/31/2019 lost
these kind of records also lost beacuse oldpolicy is there but to date is passed and this "_number" did not renew again so these kind of records also 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
in this abc policy is renewed with new _number record and to date is still not pass so these kind of records is renew
_number oldpolicy from date to date status 324 - 02/31/2019 12/31/2019 new
in this records who are in current year and old policy is also empty and to date is not pass so these kind records are new ..
so how i modified this expression according to above expressions
if(Len([Parent Policy])=0 and UW_YEAR=Year(Today()) , 'new', if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew') )
in this i use UW_Year but now i want to modified according from date and to date .. how i modified ..