filter with mininum function is not working

[unarayan]

I'm trying to set a filter where the calander_date column is greater than equal to the minimum of 2 given dates. THis is what my expression looks like:

[Business Layer].[DATE_INFO].[CALENDAR_DATE] >= minimum(to_date('31-jul-2004'), to_date('30-may-2005'))

when I try to validate this function this is the error I get:
QE-DEF-0259 tehre is a parsing error starting at position: 79, text string at 9

can some one tell me what is wrong here.

Thanks.

 

[Draoued]

why don't you change it to be :

([Business Layer].[DATE_INFO].[CALENDAR_DATE] >= to_date('31-jul-2004') OR [Business Layer].[DATE_INFO].[CALENDAR_DATE] >= to_date('30-may-2005') )