I had a similar problem, and found an answer that may be too unique to my situation to help you, but here it is anyway. Hope it helps.
http://www.tek-tips.com/gviewthread.cfm/lev2/78/lev3/80/pid/773/qid/296262
I found the answer, if anyone else runs into this.
First, I have a function that takes a time arguement and formats the time as the following: {ts '2002-07-01 15:00:00.000'}.
Then, I have a date variable defined by user input, which I also cast as a date (CDate()).
Then, I pass this date...
I am trying to write an ASP script which connects to our Remedy server with the ODBC driver provided in the client install. In my Recordset's SQL filter, I AM able to successfully query any text fields with the same field names and values as I use in the Advanced Search bar of the User Tool...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.