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 will try that. I guess the part that threw me off was that the LEFT side was my entire SELECT query up to the & and not just the EventDate.