• there are users created before 24hrs, but result is 0 rows .

    is the condition is correct ?

    createdate > DATEADD(hh,-24,GETDATE())