Hi,
I need to return a recordset from a table where records are from the last 24 hours. Currenty in a Stored Procedure I have Select .... where [DateTime] > GetDate() -1 which seemed to work quite well until today when it has suddenly been throwing up records from September .

If anybody has any ideas on a better way of doing this then any help would be appreciated.

Cheers

Shaun