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

Question

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

This Year - {1.IR.'this y'}There are a bunch of examples here too:https://help.quickbase.com/api-guide/Understanding_relative_date_ranges.htmlI 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 JunkieQuick Base Junkiehttps://quickbasejunkie.com------------------------------

miketamoush · Answer

That link is perfect!!! Thank you! I'll try this tomorrow.------------------------------Mike Tamoush------------------------------

Forum Discussion

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