Forum Discussion

Clay's avatar
Clay
Cloud Apps
04-29-2024
Solved

Calculate Days Until Date+3 Years

Hello, I am trying to calculate how many days until a certain date, provided date+3 years within a formula.  All I want to do, for example, is show how many days it is until expiration, given expira...
  • HamzaJ's avatar
    04-30-2024

    Hey Clay 

    Wouldnt this work for you?

     

    max(ddiff(NOW(),[MyDate]))+1095

    When this reaches 0 the term will expire

     

    Hamza