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.commarkshnier2@gmail.com------------------------------
Original Message:
Sent: 12-02-2019 15:04
From: Jason Johnson
Subject: Help on Formula
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
Original Message:
Sent: 12-02-2019 12:24
From: Michael Beverage
Subject: Help on Formula
Would like to have 3 pie reports one showing 30, 2nd showing 60 and 3rd showing 90
------------------------------
Michael Beverage
Original Message:
Sent: 12-02-2019 12:20
From: Austin K
Subject: Help on Formula
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?
Original Message:
Sent: 12-02-2019 12:11
From: Michael Beverage
Subject: Help on Formula
How do i write a formula that would show me 30/60/90 days before a date in a table.
------------------------------
Michael Beverage
------------------------------