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 ------------------------------
Forum Discussion
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?
Would like to have 3 pie reports one showing 30, 2nd showing 60 and 3rd showing 90
------------------------------
Michael Beverage
------------------------------
------------------------------
Michael Beverage
------------------------------
- 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
------------------------------- 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
------------------------------
