Skip to main content
Question

Report Formulas

  • August 7, 2023
  • 0 replies
  • 52 views
Forum|alt.badge.img+8

Hello there! I'm really new to Quickbase but I'm learning VERY quickly. I need to create a report that only shows employees who are 30 past their separation date and I'm trying to figure out report formulas. I cannot get anything that doesn't have some part of it that returns an error. I'm well versed in Excel and I'm getting the impression that these formulas are not the same. Can anyone help me out with a formula for this type of return? Thank you!



------------------------------
Hannah Engelson
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • August 7, 2023

    Hannah,

    Welcome to the Quickbase world.  You should be warned that Quickbase is very addictive.

    You may be overthinking your problem. You can just put in a regular filter, not a report formula,

    Where [Separation Date] "is on or after" 30 "days in the past".

    All of the above will be selected by drop downs, no coding at all.  The quotes " above are just me indicating the different drop down fields.  There is no syntax required for simple date filters.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement