Discussions

 View Only
  • 1.  How to use the Is During (IR) Operator in Formula Query

    Posted 16 days ago
    Edited by Mike Tamoush 16 days ago
    Has anyone used the Is During Operator? If I want to say 'Is During Current Year' how to do specify current year? (Or current month, etc).

    Right now, I have to go the long way and say is OnOrAfter firstdayofyear, and OnOrBefore last day of year. But I'd love to learn the shortcut if there is one!

    @Quick Base Junkie ??

    ------------------------------
    Mike Tamoush
    ------------------------------
    ​


  • 2.  RE: How to use the Is During (IR) Operator in Formula Query

    Posted 15 days ago
    This Year - {1.IR.'this y'}

    There are a bunch of examples here too:
    https://help.quickbase.com/api-guide/Understanding_relative_date_ranges.html

    I haven't tested all of them, but the few I did seem to be working in the query formula.

    If you are copying from the expanded URL in the 'more' menu the important thing to remember is to replace the "+" in query value with a space.

    Perhaps I should create a new cheat sheet for this one!

    Let me know if that does the trick 👍

    -Sharon


    ------------------------------
    Quick Base Junkie
    Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------



  • 3.  RE: How to use the Is During (IR) Operator in Formula Query

    Posted 14 days ago
    That link is perfect!!! Thank you!

    I'll try this tomorrow.

    ------------------------------
    Mike Tamoush
    ------------------------------