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(Toda...
  • 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
------------------------------