Discussions

Expand all | Collapse all

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

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

    Posted 19 days ago
    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
    ------------------------------


  • 2.  RE: Can we get "ask the user" for "date is during"?

    Posted 19 days ago
    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
    ------------------------------



  • 3.  RE: Can we get "ask the user" for "date is during"?

    Posted 19 days 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
    ------------------------------



  • 4.  RE: Can we get "ask the user" for "date is during"?

    Posted 19 days ago
    Edited by Mark Shnier (YQC) 19 days 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
    ------------------------------