>>>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.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright