SHARE
TWEET

Untitled

a guest Aug 20th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. _number oldpolicy   from date   to date   status
  2.  
  3.    213      -        01/01/2018   12/31/2018   lost
  4.      
  5. _number oldpolicy   from date   to date     status
  6.  
  7.    1234      1d23    01/01/2018   04/31/2019   lost
  8.      
  9. _number oldpolicy   from date   to date     status
  10.  
  11.    abc    abc134      01/01/2018   05/31/2019   renew
  12.    324     abc        05/31/2019   12/31/2019    renew
  13.      
  14. _number oldpolicy   from date   to date     status
  15.  
  16.    324    -             02/31/2019   12/31/2019    new
  17.      
  18. if(Len([Parent Policy])=0 and UW_YEAR=Year(Today()) , 'new',
  19. if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew')
  20. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top