hello everyone

anyway, i am working on a project where it requires me to find all the record from a table to display the record which, is expired from the current date

that means i would like to find the differences between between date retrieved from a table and date[current date] using the visual basic "Date" function ..

how do i do it, anyone has any idea that could help me???? :confused:

e.g. monthly.RecordSource = "SELECT * FROM Mmain WHERE Term='monthly'
AND " & DateDiff("d", &" MAAmain.[Date1] " &, d1) & " >31"
THANKSSS

is there any other method i can find difference too?? feel free to drop your suggestion while i can try on it..thanks [hehe]
[p/s: i am using adodc to retrieve data]

from Calverstine
my email