Forum Discussion

jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
6 years ago

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

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 u...
reports and charts
jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
6 years ago
Thanks for the reply.  I will give that a shot and see if it works for us all.  For the month, yes it was for a specific month.  "Show me all requests during X month".

------------------------------
John Ross
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
for the month is during ...
not tested for syntax but you you can make a formula field called [YYYYMM] for example 

ToText(Year([My Date Field]) & Padleft(ToText([my date field]),2,"0"))

Then the user would respond with

202001 for January 2020

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JeromeMitchell's avatar
    JeromeMitchell
    Qrew Member
    6 years ago
    My question is kind of similar.  I want to create a report that shows records if multiple date fields fall within a user defined date range . Instead of asking  if date field 1 is on or after <ask the user>  and date field 1 is on or before <ask the user > OR  date field? is on ....etc....    

    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 like
    date 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) 

    Is something like this even possible?

    ------------------------------
    Jerome Mitchell
    ------------------------------