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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
Access Invalid bracketing of parameter name 1
Pass through datetime 1
Passing Query Parameters & a Combo Box 4
Pass query parameters through multiple queries 4
Passing Parameters 5
Passing values into a doCmd.RunSQL statetment 2
Running parameter queries from VBA, suppressing parameter prompts 4

Back
Top