Please forgive me, I am a neophyte at this :)
I need to select all records created today
I can't use GetDate because it looks for a specific hour minute and second so I need a range.
ie select records created less than or equal to current date except less than 1 day ago.
I will run this query at exactly the same time everyday so that will not vary.
I can select the records of today but am not successfully excluding records of the previous day.
thank you for your advise on this.
is there a hours before function instead of days before??