i am trying to extract values based on range of dates.
Why i am getting this error
Invalidcastexception was unhandeled
Conversion from string "SELECT * FROM TBLRequest where T" to type 'Long' is not valid.
for below string
FlexString = "SELECT * FROM TBLRequest where TBLRequest.PrDate >='" & Date.Parse(TxtDateFrom.Text) And "TBLRequest.PrDate<='" & Date.Parse(TxtDateTo.Text) & "'"
Edited 2 Years Ago by PM312