Can we get "ask the user" for "date is during"?

Question

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

markshnier__you · Answer

Well, 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
------------------------------

jrossausiscom · Answer

Thanks for the reply.&nbsp; I will give that a shot and see if it works for us all.&nbsp; For the month, yes it was for a specific month.&nbsp; "Show me all requests during X month".------------------------------John Ross------------------------------

markshnier__you · Answer

for the month is during ...not tested for syntax but you you can make a formula field called [YYYYMM] for example&nbsp;ToText(Year([My Date Field]) &amp; Padleft(ToText([my date field]),2,"0"))Then the user would respond with202001 for January 2020------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jeromemitchell · Answer

My question is kind of similar.&nbsp; I want to create a report that shows records if multiple date fields fall within a user defined date range . Instead of asking&nbsp; if date field 1 is on or after &lt;ask the user&gt;&nbsp; and date field 1 is on or before &lt;ask the user &gt; OR&nbsp; date field? is on ....etc....&nbsp; &nbsp;&nbsp;I just want to be able to ask the user the start date and end date (these would be variable fields i guess) , then use my logic to say something likedate field 1 is on or after the value in the field (start date) and date field 1 is on or before the value in the field (end date)&nbsp;Is something like this even possible?------------------------------Jerome Mitchell------------------------------

Forum Discussion

Can we get "ask the user" for "date is during"?

Related Content

Field to "assign" a user group

"User has been removed"

Validation error: Incorrect template "{{c.user.id}}". ValueError: invalid literal for int() with base 10: 'user'

Record "Last Modified" Date

API for "Last Visited" data of a user