Skip to main content
Solved

Records created in the last 24 hours

  • Dec 7, 2023 9:37 PM UTC
  • 0 replies
  • 198 views
Forum|alt.badge.img+6

I'm trying to find the number of records created in the last 24 hours using the following code, but getting a type mismatch error, any advice?

Count(If([Date Created] > ToTimestamp(ToDate(Today()) - 1), 1, null))


------------------------------
Troy MacPherson
------------------------------

Best answer by TroyMacPherson

solved my own problem I think:

Count(If([Date Created] > Now()-Hours(24), 1, null)) 



------------------------------
Troy MacPherson
------------------------------
View original
    This topic has been closed for replies.

    Forum|alt.badge.img+6
    • TroyMacPherson
    • Author
    • Qrew Member
    • Answer
    • Dec 7, 2023 9:44 PM UTC

    solved my own problem I think:

    Count(If([Date Created] > Now()-Hours(24), 1, null)) 



    ------------------------------
    Troy MacPherson
    ------------------------------
    MarkShnierYou
    Forum|alt.badge.img+24

    Can you explain what you mean by the last 24 hours?  Do you mean that literally?  Like a rolling last 24 hours. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement