How to retrieve data 48 hours old

maskme · April 29th, 2004, 09:06 AM

Hi i wish to retrieve from my database table, records that are 48 hours old. I've a date field in the database table. How do i do it. Pls help me.

Thank u very much

owain · April 29th, 2004, 09:16 AM

This should work for a SQL Server database:

Code:

SELECT * FROM YourTable
WHERE DateField > (GetDate() - 2)

Or if you have an Access database then this should work:

Code:

SELECT * FROM YourTable
WHERE DateField > (Date() - 2)

I hope that helps.

Regards
Owain Williams