Can anyone tell me what is wrong with this?
Month({Command.Date_Received}) IN [({?ParamMValue})]
?ParamMValue could have... (2,3,4,5) or (2) or (1,2,3,4,5,6,7,8,9)
Why is it telling me that I need a number range in the IN statement?
What should I do instead?Make sure your parameter is a number data type and not a date or string.
GJ|||your final formula should be in format like this..
month({field}) in [ parameter ] no need to you [(2,3,5)]..
Hope this helps yousql
Showing posts with label thismonth. Show all posts
Showing posts with label thismonth. Show all posts
Monday, March 26, 2012
number range in the IN statement
Subscribe to:
Posts (Atom)