I've had a similar problem this morning. An entry of '01/01/2001' has worked for years but today nada. I think the DBA changed a default on a datetime field of the Oracle table. Did you try a format like '01-JAN-2001'? That seems to work OK for me.
Sammie
>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