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 Junkie
Quick Base Junkie
https://quickbasejunkie.com------------------------------
