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!

I'm thinking the format of your date is causing the problem. Try
this:

Sub foo()
Dim str As String
str = "SELECT * FROM login WHERE nextcpr <= #" & Format(DateAdd("d",
30, Now()), "Short Date") & "#;"
Debug.Print str
End Sub

Results of Immediate window:
SELECT * FROM login WHERE nextcpr <= #6/12/2004#;

That looks like good SQL to me.

HTH,
Johnny

You can use Now()+30, since this adds days.

So... "#" & format(now+30, "Short Date") & "#".

- Andrew Backer

jjrmy1 (AT) earthlink (DOT) net wrote: