SQL parameter query

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

Guest

I have a pass through to SQL that I need to pass a parameter to.

WHERE (((v.DateDiagnosis)>= '?' And (v.DateDiagnosis)< '?')

Doesn't work. What is the correct syntax?

Thanks!!
 
If your query is hitting against Oracle then the parameter date needs to be
in a specific string format. The format is 'DD MMM YYYY'.

So it should look something like this...

WHERE (((v.DateDiagnosis)>= '01 OCT 2005' And (v.DateDiagnosis)< '01 NOV
2005')
 
Back
Top