Skip to main content
Question

Formula to restrict data within a daily time period

  • February 14, 2024
  • 0 replies
  • 59 views
Forum|alt.badge.img+1

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement