Hi,
try this:
select * from tblEvents where (CONVERT(varchar(24),tblEvents.dateEventDate,100)+' '+CONVERT(varchar(20),timeStartTime,100)) between (GETDATE()) and (DATEADD(D,-1,GETDATE()))
Your code is not working, since GetDate returns a DateTime value, this means if you substract 1, you don't substract 1 day!