calculating difference between two dates in access
Hare Shiva
Greenhorn
Joined: Jul 08, 2012
Posts: 12
posted
0
I have a table in which there is an attribute called SDate where i am storing Date.Now i need to select all rows from that table where the difference of current date and SDate is greater than 1 day.Please help me and also i think this problem is better solved if i add timestamp value.
select * from TeleQuery where DateDiff("d",SDate,Date())>1
If i use above query then rows with SDate 10/1/2012 doesnot get selected even though the difference between SDate and current Date 10/2/2012 is more than 1 day.Why is it not working?I am using access.
Seems to me that the difference between 10/1/2012 and 10/2/2012 is 1 day. And 1 is NOT greater than 1.
However I also think that your DateDiff function will return -1 for yesterday's date and not 1. Are you sure you have the two date parameters in the correct order?
0
