I get the error message "Expected TRUE/FALSE" when setting this filter 
expression

text LIKE '%sometext%' AND string(from_date, 'YYYYMMDD') > = Today()

It should be possible to combine LIKE with other expressions? 

Try reversing the expressions.

This works...
date( string(entry_datetime,'yyyy/mm/dd') ) = today() and  state like 'S%'

But this doesn't...
state like 'S%' and date( string(entry_datetime,'yyyy/mm/dd') ) = today()

hth,
Mark

On 12/7/2010 9:22 AM, O.Steine wrote:
> I get the error message "Expected TRUE/FALSE" when setting this filter 
> expression
>
> text LIKE '%sometext%' AND string(from_date, 'YYYYMMDD') > = Today()
>
> It should be possible to combine LIKE with other expressions?

You have to use parentheses around the different sesctions when using the 
like statement, or move the like to the end:

string(from_date, 'YYYYMMDD') > = Today() and text LIKE '%sometext%'
or
(text LIKE '%sometext%') AND (string(from_date, 'YYYYMMDD') > = Today())

-- Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"O.Steine"  wrote in message news:4cfe430f@forums-1-dub...

I get the error message "Expected TRUE/FALSE" when setting this filter
expression

text LIKE '%sometext%' AND string(from_date, 'YYYYMMDD') > = Today()

It should be possible to combine LIKE with other expressions? 

Yes, but its precedence is messed up in the dw expression engine, so you 
need to wrap the clause in parens:

(text LIKE '%sometext%') AND string(from_date, 'YYYYMMDD') > = Today()

Ken

"O.Steine" <osteine@gmail.com> wrote in message 
news:4cfe430f@forums-1-dub...
>I get the error message "Expected TRUE/FALSE" when setting this filter 
>expression
>
> text LIKE '%sometext%' AND string(from_date, 'YYYYMMDD') > = Today()
>
> It should be possible to combine LIKE with other expressions? 

> ... AND string(from_date, 'YYYYMMDD') > = Today()

The second condition is not valid - you are comparing a string with a date. 
Do not rely on implicit conversion (even if it works in the version you are 
using - it doesn't in 11.2 or 12 )

Thank you all :)

Works like a charm!!

"Ken Balakrishnan"  skrev i nyhetsmeldingen: 4cfe4885$1@forums-1-dub ... 

Yes, but its precedence is messed up in the dw expression engine, so you 
need to wrap the clause in parens:

(text LIKE '%sometext%') AND string(from_date, 'YYYYMMDD') > = Today()

Ken

"O.Steine" <osteine@gmail.com> wrote in message 
news:4cfe430f@forums-1-dub...
>I get the error message "Expected TRUE/FALSE" when setting this filter 
>expression
>
> text LIKE '%sometext%' AND string(from_date, 'YYYYMMDD') > = Today()
>
> It should be possible to combine LIKE with other expressions?