Forum Discussion
Filter A Query Based on Parameters
The report is as the error says "Expression.Error: We cannot apply operator & to types Text and DateTime."
Change the StartDate to text rather than date/time. Then it works in my test. Regarding date type conversion, in many databases, a formated string "20160804" or 2016-08-04" can be implicitly converted to date correctly. No worry about the conversion.
The report is as the error says "Expression.Error: We cannot apply operator & to types Text and DateTime."
Change the StartDate to text rather than date/time. Then it works in my test. Regarding date type conversion, in many databases, a formated string "20160804" or 2016-08-04" can be implicitly converted to date correctly. No worry about the conversion.
I'm trying to pass date as parameters and have changed it to text. However, when i pass the value like 4/4/2017 , I'm getting incorrect syntax near '/' . Could you kindly help?
Bibek wrote:
Hi Eric_Zhang
I'm trying to pass date as parameters and have changed it to text. However, when i pass the value like 4/4/2017 , I'm getting incorrect syntax near '/' . Could you kindly help?Since this thread is old and closed, for your question, could you please raise a new thread?
Eric_Zhang No issues. I have found the solution. However, I have another query for which I'll raise a new thread.