pass date parameter

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

Guest

I am passing a date entered by the user ( from an input box) to the TSQL
statement for a pass-through query. What is the correct syntax in the WHERE
clause for the user's entry? Here is what I have, I know the # is wrong:

AND ((t.ApptDate)> #1/1/2005#)

Thanks!!
 
Back
Top