getdate() gives you current date time... converting (convert) it to string and trimming off (substring) the time portion will give you todays calendar date which you can look for all >=... or you cand use dateadd to get yesterday's...