Getting error with case statement in filter....

[everlearner]

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

[Lynn]

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

[everlearner]

Thanks Lynn, its worked out..