Forum Discussion

HubertZieciak's avatar
HubertZieciak
Frequent Visitor
7 years ago

Date + x months

Hi,

I need to calculate a number of days from:

  • signing a contract (date field )
  • Tenor - Time that contracts lasts (number field)

Adding tenor to the date should give me an ending date; than I need  to count number of days between two dates.

Need Help

3 Replies

    • HubertZieciak's avatar
      HubertZieciak
      Frequent Visitor
      7 years ago

      Hi,

       

      First I need to figure out exact ending date. How to calculate from starting date (date field) and number of months (number field) contract is going on.

      • judspud's avatar
        judspud
        Icon for Solution Supplier rankSolution Supplier
        7 years ago

        you can use the DATEADD function for that :)