Skip to main content
Question

How to use the Is During (IR) Operator in Formula Query

  • May 9, 2022
  • 0 replies
  • 123 views
Forum|alt.badge.img+20
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
------------------------------
​

QuickBaseJunkie
Forum|alt.badge.img+15
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
------------------------------
Terms & ConditionsAccessibility statement