Forum Discussion

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

    solved my own problem I think:

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



    ------------------------------
    Troy MacPherson
    ------------------------------
  • TroyMacPherson's avatar
    TroyMacPherson
    Qrew Cadet
    10 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
    Icon for Qrew Legend rankQrew Legend
    10 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
      10 months ago

      Hi Mark, 

      Correct - rolling 24-hour period.  



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