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?
![]() |
0 |
![]() |
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?
![]() |
0 |
![]() |
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?
![]() |
0 |
![]() |
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?
![]() |
0 |
![]() |
> ... 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 )
![]() |
0 |
![]() |
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?
![]() |
0 |
![]() |