Forum Discussion

JennyMarshall's avatar
JennyMarshall
Qrew Trainee
7 years ago

Can a formula be written to have a date automatically update dependent on information in two other fields?

I am trying to have an expiration date automatically update based on if the contract auto-renews and the fields of how many days (how often) it renews.  I need help writing a formula or if there is an...
Formulas and functions
Tables and fields
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
7 years ago
//Original Expiry Date
AdjustMonth([Effective],[Term]);
//End

//Endless Renewals - Stopping once you enter a termination date - Updated Expiry Date

var date initialExpiration = AdjustMonth([Effective],[Term]);
var number numberOfRenewals = 
ToDays(
if( not isnull([Termination Date]), [Termination Date], Today()) - $initialExpiration) / [Renewal (Days)]);

if( 
     [Renewal Exposure]="Auto-Renewal" and 
     Today() > $initialExpiration, 
$initialExpiration + Days(Ceil($numberOfRenewals)*[Renewal (Days)]),
$initialExpiration)

//End

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base