Forum Discussion

TroyMacPherson's avatar
TroyMacPherson
Qrew Cadet
5 months ago

Records created in the last 24 hours

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
------------------------------

3 Replies

Sort By
  • TroyMacPherson's avatar
    TroyMacPherson
    Qrew Cadet
    5 months ago

    solved my own problem I think:

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



    ------------------------------
    Troy MacPherson
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 months ago

    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
    ------------------------------
    • TroyMacPherson's avatar
      TroyMacPherson
      Qrew Cadet
      5 months ago

      Hi Mark, 

      Correct - rolling 24-hour period.  



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