Calculating an Expiration Date

How to calculate and set an expiration date or due date

Knowing when something expires is super helpful so when you want to set a specific expiration date you can use something like:

As long as our date value is not blank we add 10 years to that date to determine an expiration date determined by our Date Type and the number we add.

{Mitigation Fees Paid Date} !=0 ? {Mitigation Fees Paid Date} + 10 : null

You can opt out of using Time but if you choose hours as your Date Type, its probably best to include Time in your result unless you are only doing 24 hour increments.

Last updated