Hello,
I'm fairly new to Macros, and where I'd never struggle with this in VBA, simple things with Macros are foxing me.
I have a Web-Table with a Date Field [CaseDate]
I have two search boxes, [DateFrom] and [DateTo] - I need to filter the table based on the dates in the search boxes and return the cases between these two dates.
I'm setting two Local Variables, DateStart and DateEnd
I know BETWEEN cannot be used in Web Forms. But [CaseDate] => [localVars]![DateStart] And =< [localVars]![DateEnd] is coming back as an invalid Macro.
Can someone help me?
Thanks!
I'm fairly new to Macros, and where I'd never struggle with this in VBA, simple things with Macros are foxing me.
I have a Web-Table with a Date Field [CaseDate]
I have two search boxes, [DateFrom] and [DateTo] - I need to filter the table based on the dates in the search boxes and return the cases between these two dates.
I'm setting two Local Variables, DateStart and DateEnd
I know BETWEEN cannot be used in Web Forms. But [CaseDate] => [localVars]![DateStart] And =< [localVars]![DateEnd] is coming back as an invalid Macro.
Can someone help me?
Thanks!