Hello - I am trying to get all records that have been updated (last modified) from today minus 1 day. The following T-SQL does not bring any results. The [LastModified] column is [datetime] field. Thanks for your help.
select LastName, FirstName, personid, LastModified from MyTable
where LastModified = DATEADD(DAY,-1, GETDATE())