Hi Gurus,
case ?DateType?
when 'Start Date' then (([Start Date] >= ?frm_date?) and ([Start Date] <= ?to_date?))
when 'End Date' then ( (End Date] >= ?frm_date?) and ([End Date]<= ?to_date?))
when 'Cancelled Date' then ( ([cancelled Date]>= ?frm_date?) and ([cancelled Date] <= ?to_date?))
End
This is what i wrote in filter. am getting error message " UDA-SQL-0358 syntax error near >=".
i have tried it with in_range by single parameter and also tried with BETWEEN, AND. nothing worked out.
can any one tell me, how to fix.
thanks in adv
Ah, filters want expressions that are Boolean so evaluation results in true or false.
Try something like this:
(
?datetype? = 'startdate'
and
{put your logic here}
)
or
(
?datetype? = 'enddate'
and
{put your logic here}
)
Sent from my iPhone using Tapatalk
Thanks Lynn, its worked out..