Forum Discussion

RachelDifiore's avatar
RachelDifiore
Qrew Member
4 months ago

Formula to restrict data within a daily time period

Hello all, hopefully someone can help me figure this out.

I have a large daily data set that has fields by time, both by hour and by actual time. I am looking to separate some of the records into a particular time period. Is there a formula I can use that will add a checkmark to records between the hours of 12 and 16 (4pm)? I'm currently at a loss, and formulas aren't my strong suit to begin with. I appreciate any feedback.



------------------------------
Rachel Difiore
------------------------------

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 months ago

    np, we can help.  Can you tell us the field type that you are dealing with to hold these dates and times.  Can you tell us the field types that hold the data?

    If you have  a field which is already a Time Of Day field type you can use this formula.

    [My time of day field] >= ToTimeOfDay("12:00 pm") 

    and

    [My time of day field] <= ToTimeOfDay("4:00 pm") 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • RachelDifiore's avatar
      RachelDifiore
      Qrew Member
      4 months ago

      I have a Time of Day field (Sched Dept) and a numeric formula for Hour. I'd want to restrict either one of those to restrict files within those hours. 



      ------------------------------
      Rachel Difiore
      ------------------------------
      • RachelDifiore's avatar
        RachelDifiore
        Qrew Member
        4 months ago

        It worked! Sometimes the simplest things trip you up. Thanks for the help!



        ------------------------------
        Rachel Difiore
        ------------------------------