| | |
|
|
|
whatswrong? |
|---|
| message from jjrmy1 on 12 May 2004 |
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!
|
| anonymous replied to jjrmy1 on 12 May 2004 |
WHERE nextcpr = Date() +30
select all records
column nextcpr. i use
days or less,
30, Now()) &"#"
|
| anonymous replied to jjrmy1 on 12 May 2004 |
try this
WHERE nexttcpr BETWEEN DATE()-30 and DATE()
select all records
column nextcpr. i use
days or less,
30, Now()) &"#"
|
|
Archived message: whatswrong? (Microsoft Access Forms)
