:)
Actually they could be {^2002/1/1} and {^2002/1/31} respectively. They're implicitly converted to {^2002/1/1 12:00:00 AM},{^2002/1/31 12:00:00 AM}.
Cetin

>Thanks!!!!
>
>I got it to work the way you first specified by using the format
>
>{01/01/2002 00:00:00} for the startdatetime
>
>and
>
>{01/31/2002 00:00:00} for the enddatetime for the EXAMPLE part of the Remote View...
>
>I will certainly KEEP your replies in my printouts!!!
>
>Thanks again!
>
>Tommy
>>Oh if you do that way then backend expects to get in ODBC canonical format :
>>
>>transform(ttoc(dtot(ldDate),1),'@R 9999/99/99 99:99:99')
>>
>>You might try shorter form :
>>transform(dtoc(ldDate,1),'@R 9999/99/99')
>>
>>Cetin
>>
>>>I'll give this a try... I was using the Remote View Wizard and trying to use some static values to get a feel for the syntax that Oracle wants....
>>>
>>>I was using stuff like '01/01/2001' ... ^2002-01-01 ... and the like but nothing would work....
>>>
>>>>>I have to set up a remote view with a parameterized datetime field...
>>>>>
>>>>>Question 1 - After selecting the paydate (datetime) field in the selection criteria and selecting equals.... what do I type in for the EXAMPLE... I can't seem to get this right without getting an error (column not found - or else incorrect month).
>>>>>
>>>>>Question 2 - For a datetime range (between a lower date and an ending date), what would the example be?
>>>>>
>>>>>Thanks for the help....
>>>>>
>>>>>Tommy
>>>>
>>>>Tommy,
>>>>I don't use Oracle but it should be same as in SQL server :
>>>>
>>>>

>>>>*1)
>>>>SQLExec(handle,"select * from myTable"+;
>>>> " where myDate = ?thisform.txtPayDate.Value",'Result')
>>>>
>>>>*2)
>>>>SQLExec(handle,"select * from myTable"+;
>>>> " where myDate between "+;
>>>> "?thisform.txtStartDate.Value and ?thisform.txtEndDate.Value", 'Result')
>>>>

Cetin