Getting Started

 View Only
  • 1.  Formula to Calculate EST. Exhaustion Date

    Posted 10-20-2022 14:16
    Hello I'm currently trying to calculate what would be our "Estimated Exhaustion Date" of service provided to our customers.

    Currently within our excel spreadsheet that we are converting to QB, we have a field that takes the information from another field labeled as "Months Coverage Remaining" which is a number field that contains data of how many months remain of active coverage for our customers, that information is then added to today's date in order to calculate the Estimated Date we are to stop service. 

    The issue i'm running into is the "Months Coverage Remaining", is a number field and doesn't allow me to add it to a date. Is there anything that could convert said number field to a date to complete the formula? Or what would be the best option to go about this calculation? 

    Thank you for all your hard work!

    ------------------------------
    Christopher Angulo
    ------------------------------


  • 2.  RE: Formula to Calculate EST. Exhaustion Date

    Posted 10-20-2022 14:20
    np
    AdjustMonth(Today(), [Months Coverage Remaining])

    Bookmark this handy list of all the built in functions w/examples

    https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000087


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula to Calculate EST. Exhaustion Date

    Posted 10-20-2022 14:33
    Thank you for that very helpful link!! I book marked it right away. Also thank you for the fast assistance again it is much appreciated.

    ------------------------------
    Christopher Angulo
    ------------------------------