hello everyone
javascript:insertsmilie(':)')Smile

anyway, i am working on a projectjavascript:insertsmilie('')
Cool 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????

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
[email protected]
:)