Discussions

Expand all | Collapse all

Help on Formula

  • 1.  Help on Formula

    Posted 11 days ago
    How do i write a formula that would show me 30/60/90 days before a date in a table.

    ------------------------------
    Michael Beverage
    ------------------------------


  • 2.  RE: Help on Formula

    Posted 11 days ago
    Which one would you like the formula to display? Are there any triggers that would make it display 30 instead of 90? Or do you want it to display all of those at once?


  • 3.  RE: Help on Formula

    Posted 11 days ago
    Would like to have 3 pie reports one showing 30, 2nd showing 60 and 3rd showing 90

    ------------------------------
    Michael Beverage
    ------------------------------



  • 4.  RE: Help on Formula

    Posted 11 days ago
    You would need 3 fields to calculate those dates and the formula will depend on if you are looking at 30 days including weekends or not. It would be a formula date field. Change the number for 60 and 90.
    Not including weekends
    WeekdayAdd([Start Date], -30)

    Including weekends
    WorkdayAdd(ToWorkDate([Start Date]), -30)

    ------------------------------
    Jason Johnson
    ------------------------------



  • 5.  RE: Help on Formula

    Posted 11 days ago
    You will need to have a field which calculates to the words 30 days,  60 days  or 90 days and if you want a pie chart, it will need to be one fields and not three fields.  Essentially you are looking to "bucket" the records into three groups.

    Try this

    IF(
    Today() + Days (0) > [My Date field], "Date is passed"
    Today() + Days (30) > [My Date field], "Within 30 days"
    Today() + Days (60) > [My Date field], "Within 60 days"
    Today() + Days (90) > [My Date field], "Within 90 days",
    not isnull([My Date field]), "90+ days")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------