Forum Discussion

TroyMacPherson's avatar
TroyMacPherson
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(Toda...
  • TroyMacPherson's avatar
    2 years ago

    solved my own problem I think:

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



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