Help on Formula

Question

How do i write a formula that would show me 30/60/90 days before a date in a table.------------------------------Michael Beverage------------------------------

markshnier__you · Answer

You will need to have a field which calculates to the words 30 days,&nbsp; 60 days&nbsp; or 90 days and if you want a pie chart, it will need to be one fields and not three fields.&nbsp; Essentially you are looking to "bucket" the records into three groups.Try thisIF(Today() + Days (0) &gt; [My Date field], "Date is passed"Today() + Days (30) &gt; [My Date field], "Within 30 days"Today() + Days (60) &gt; [My Date field], "Within 60 days"Today() + Days (90) &gt; [My Date field], "Within 90 days",not isnull([My Date field]), "90+ days")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

austink · Answer

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?

michaelbeverage · Answer

Would like to have 3 pie reports one showing 30, 2nd showing 60 and 3rd showing 90------------------------------Michael Beverage------------------------------

jasonjohnson2 · Answer

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

Forum Discussion

Help on Formula

Related Content

Formula Assistance

Formula Query with custom key

Formula Url Buttons

Formula Date Field

Date Field Formula