Jason,

Where dTradingDate comes from and what type it has? What's not working exactly?


>I have a table that has the following columns:
>
>nlUnit int
>tDate nvarchar(10)
>ndAmount float
>
>I want to retrieve a recordset that converts the tDate to a datetime. I am using the following to do so:
>
>SELECT nlUnit, CONVERT(datetime, tDate) AS dDate,ndAmount
>
>My issue is that I want to also use a where statement like
>
>WHERE (ndAmount >= 50.00) and (dTradingDate BETWEEN '4/1/03' AND '4/15/03')
>
>This is not working. I am retrieving my recordsetand then applying a date filter to it.
>
>Does anyone know the correct syntax for the above. If not, is there a better work-around?
>
>Thanks in advance.