Skip to main content
Question

Adding days to a date field.

  • April 4, 2017
  • 0 replies
  • 57 views
I have policies that expire in a specific number of days. Using the AdjustMonth function causes the expiration to be inaccurate. I have a numeric field with the number of days. "Term Days"
How do I calculate the expiration date base on the effective date?
Fields are "Policy Effective Date" which is a date field and "Policy Expiration Date" which is a Date - Formula field. 
Thanks!
      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • April 4, 2017
      use the Days(X) expression

      [Policy Effective Date]+Days([Term Days])
      • DavidDziewit
      • Author
      • Quickbase Alumni
      • April 5, 2017
      Worked like a charm! Thanks!
      • anomDiebolt
      • Quickbase Alumni
      • April 5, 2017
      Henceforth please place all of your formulas (and script etc) inside a <pre> element. This will make my job of scraping all the formulas out of the forum for testing my formula parser much easier and the formulas will be easier to read in a monospace font:
      [Policy Effective Date]+Days([Term Days])
      To place your formulas in a <pre> tag just type or paste your formula as normal, then highlight the text and press the pre icon as shown below:

      Terms & ConditionsAccessibility statement