Try this:
where nextcpr <= int(date()+30)
<jj****@earthlink.net> wrote in message
news:%B*******************@newsread1.news.pas.eart hlink.net...
does any one see anything wrong with this? I'm trying to select all
records in which it is only 30 days untill the date entered in column nextcpr. i
use format mm/dd/yyyy. it must always select the records 30 days or less,
greater than the current date.
"SELECT * FROM login WHERE nextcpr <= #"& DateAdd("d", 30, Now()) &"#"
thanks in advance for your help!
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.683 / Virus Database: 445 - Release Date: 12/05/2004