Skip to main content
Question

Hour Comparison

  • December 13, 2022
  • 0 replies
  • 41 views
Hello quickbase community,

I have a question:
Is it possible to compare which hour is greater between one and the other?

For example:
if [Date Created] is less than 7:30 AM return "Created outside business hours"

Regards, 

Herberth Solano.

------------------------------
Herberth Solano
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    • MikeTamoush
    • Registered
    • December 13, 2022
    You will need to Use the ToTimeOfDay function to turn everything into a recognized time, and also have multiple conditions to check if it is between business hours (less than 7:30am doesnt mean much. 2pm the prior day is less than 730am...)

    If(
       ToTimeOfDay([Date Created]) <  ToTimeOfDay("7:30am")  and
       ToTimeOfDay([Date Created]) >  ToTimeOfDay("5:00pm"),

       "Created outside of business hours"
    )

    Check the to time of day function to be sure my syntax of 7:30am is correct. not sure if you need to use a 24 hour clock or anything, but I think it accepts all standard time formats.

    ------------------------------
    Mike Tamoush
    ------------------------------
    Terms & ConditionsAccessibility statement