I need to look up any entries for a given user in the last day, note not 24 hours. I tried using DATE_SUB but keep getting no results even though there is date. The field in question is a datetime field and was created using NOW() during the record insert.
Thanks in advance.