whatswrong?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

What's the context? Where do you have this text string ane what are
you doing with it?
 
Back
Top