Contract Duration

PHOTO EMBED

Wed May 20 2026 08:46:00 GMT+0000 (Coordinated Universal Time)

Saved by @archer 

if [enddate] <> "1/1/1901" then
    if ([Contract Status]="FiT" or [Contract Status]="CSL Takeover" or [Contract Status]="Name Transfer-Death" or [Contract Status]="Orig owner sold house to FiT") then
         Duration.Days([enddate] - [fitcommencement]) + 1 
    else 
        0
else
    0
content_copyCOPY