>>>try using {^yyyy-mm-dd}
>>
>>I've got this working using remote views. Is there any way to do this with SPT?
>

---

>Thought that should work. You can look in the documentation of the sql server.
>You can try to use something like date(Year,Month,Day)


The problem was that if I wanted to create the sql string, it wouldn't be in the correct format. I resolved it by having my code look something like this:

DSNLess = SQLCONNECT("tandem")
lcdate={^2000/09/07}
lcsql='SELECT * FROM PROD_MANAGER.CJ90 WHERE PROD_MANAGER.Cj90.RSDCT = ?lcdate'
sqlexec(dsnless,lcsql,'mycursor')

Parameterized view in the SPT.

Thanks again.