Just realized that you cannot say "X date is during" - "ask the user". In the case where I need users to be able to say show me all records during X year or month. The only thing we figured out is using two specific dates but this is a bit messy and less convenient.
Any chance this could be added?
------------------------------
John Ross
------------------------------
Question
Can we get "ask the user" for "date is during"?
+6This topic has been closed for replies.
+24Well, for asking the user if the date is during some year, you would just have the user answer with the year number like
2020
and the report would compare the 2020 to a formula called [Year] which is
Year([my date field])
As for answering the during for a month, were you asking the user for one month or a range of months.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
2020
and the report would compare the 2020 to a formula called [Year] which is
Year([my date field])
As for answering the during for a month, were you asking the user for one month or a range of months.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.