Rowfilter & to_date function for Oracle


New member
Mar 15, 2005
Programming Experience
Hello, I am having some difficulty making some changes to an existing app. It was coded to take advantage of rowfilters to retrieve specific information.

What I have is an Oracle database populating a dataview, and the rowfilter trying to pull out specific rows within a date range. here is that code:

rowFilter = "BEGINDATE BETWEEN to_date('" & _

Format([/size][size=2][color=#0000ff]Me[/color][/size][size=2].DateRangeBeginPicker.Value, "MM/dd/yyyy") & _

"', 'MM/DD/YYYY') AND to_date('" & _

Format([/size][size=2][color=#0000ff]Me[/color][/size][size=2].DateRangeEndPicker.Value, "MM/dd/yyyy") & _

"', 'MM/DD/YYYY')"


The syntax is correct; it works in PL/SQL. The error that is returned is this:

An unhandled exception of type 'System.Data.EvaluateException' occurred in
Additional information: The expression contains undefined function call to_date().

It seems like VB.Net is catching the function and not passing it to Oracle, as I'm not getting an ORA-XXXXX error... what am I doing wrong?
Top Bottom