Forum Discussion

MichaelBeverage's avatar
MichaelBeverage
Qrew Member
5 years ago

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
------------------------------
Formulas and functions

4 Replies

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years 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?
    • MichaelBeverage's avatar
      MichaelBeverage
      Qrew Member
      5 years ago
      Would like to have 3 pie reports one showing 30, 2nd showing 60 and 3rd showing 90

      ------------------------------
      Michael Beverage
      ------------------------------
      • JasonJohnson2's avatar
        JasonJohnson2
        Qrew Cadet
        5 years 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
        ------------------------------