pass date parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smk23 - 30 Jan 2006 22:43 GMT

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

Signature

sam

Reply to this Message

Ofer - 30 Jan 2006 22:50 GMT

Try a single quote

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

Signature

\\// Live Long and Prosper \\//
BS"D

> 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
[quoted text clipped - 3 lines]
>
> Thanks!!

Reply to this Message