Forum Discussion

Qrew Cadet

2 years ago

Solved

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
2 years ago
solved my own problem I think:

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

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

3 Replies

TroyMacPherson
Qrew Cadet
2 years ago
solved my own problem I think:

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

------------------------------
Troy MacPherson
------------------------------
MarkShnier__You
Qrew Legend
2 years 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
  Qrew Cadet
  2 years ago
  Hi Mark,
  
  Correct - rolling 24-hour period.
  
  ------------------------------
  Troy MacPherson
  ------------------------------