Hello Sir
I want to retreive the record that is saved on one day before the current
date.i wrote the following query but it dose not retreive the record.

SELETC * FROM Readings WHERE Readings.Date=Date-1;

but it don't retreive record .
Have any body any idia to solve this problem.

Thanks

arshad mahmood

__________________
arshad mahmood

You can not write like date = date-1. You will have to generate new date in the specified format.


Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

Give this a shot:

SELECT *
FROM Readings
WHERE Readings.Date=DateAdd("d", Date, -1);

Hope this helps......

Kenny Alligood