DateDiff with a User-specified Parameter

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

Guest

The query calculates the datediff of two dates and has a parameter >=[Minimum
Age:]. The datediff works fine but when specifying the age, most records
return, including those that are outside the range. If the value is put on
the parameter line, It WORKS! It's just that the run-time parameter is
largely, but not entirely, ignored?

What's the solution?
Thanks!
RO
 
No, runtime parameters are not ignored. Could you post the SQL of the query
that is giving you "bad" results? It may be something as simple as you having
to declare the parameter type so the SQL query understands what you are entering correctly.
 
Back
Top