warun 0 Newbie Poster

Dear Friends
DataView is pouplated from an oracle database table and when i tried to Filter records which has been created in between two dates gives me misguiding rows. I have tried with different date format, still getting wrong information.

Dim dt as New DataSet, dv as New DataView
Dim mAdapt = New OracleDataAdapter("SELECT * FROM Order", _Conn_)
       mAdapt.SelectCommand.CommandType = CommandType.Text
       mAdapt.Fill(dt, "Order")

dv.Table = dt.Table("Order")

dv.RowFilter = "Order_Date >= #"  & Format(mFromDt, "MM/dd/yy")  & "# AND " & _
                Order_Date <= #" & Format(mToDt, "MM/dd/yy") & "#"

'mFromDt and mToDt are Date Type Variable.

Is anything wrong in Date Format or Character which enclosed Date Literal ?

Warun