Re: Help on Formula

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
------------------------------