Okay how about this:

'Search Bar' LIKE ("%" + "'Create Date'%<" + "%")

Steve

On 4/7/08, Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> wrote:
>
> Steve,
>
> I've already tried to do something like this...
> but I wanted to simplify the condition...
>
> I wouldn't like to use a code like these:
>
> ('Search Bar' LIKE ((("%" + "'Create Date'<") + "%")))      ==> with no
> blank spaces
> OR
> ('Search Bar' LIKE ((("%" + "'Create Date' <") + "%")))     ==> with one
> blank space
> OR
> ('Search Bar' LIKE ((("%" + "'Create Date'  <") + "%")))    ==> with two
> blank space
> OR
> ('Search Bar' LIKE ((("%" + "'Create Date'   <") + "%")))   ==> with three
> blank space
>
> and so on...
>
> I'd like to know if there is a way for me do this with a rule that is used
> for "n" blank spaces...
>
>
> Remember that I've tried to use "%" but this does not work because of
> this, for example:
> 'Create Date' > "01/01/2007" AND 'Status' < 3
>
> Thankx for all...
>
> Yours Sincerelly,
>
> Tadeu Augusto Dutra Pinto
> -----------------------------------------------------------------
> IT Web Services ATM
> Cinq Technologies
> http://www.cinq.com.br <
> https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/
> >
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Fone: 41 3018-2833 - Cinq
> Fone: 41 2107-5736 - HSBC Outsourcing
> -----------------------------------------------------------------
> Confiabilidade, Inovação e Qualidade em T.I.
>
>
> ________________________________
>
> De: Action Request System discussion list(ARSList) em nome de Steven
> Pataray
> Enviada: seg 7/4/2008 12:43
> Para: [email protected]
> Assunto: Re: Using 'Search Bar' with 'Create Date'
>
>
> **
> This looks almost like yours but it worked for me.
>
> 'Search Bar' LIKE ("%" + "'Create Date' <" + "%")  OR 'Search Bar' LIKE
> ("%" + "'Create Date'<" + "%")
>
>
> Steve
>
>
> On 4/7/08, Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> wrote:
>
>        Hello,
>
>
>        I'm trying to do this funcionallity ...
>
>        When I put "'Create Date' <" this works very well....
>        But when I put "'Create Date'<" (withou blank spaces between
> "'Create Date' and <" ) this does not work...
>
>        and, consequently, when I put another cause of condition that go
> out of my specific case (i.e. "'Create Date' <")
>        this doesn't work fine ...
>
>        Is there a way that I can create a condition that works fine?
>        I've tried to put "'Create Date'" + "%" + "<" , but when I have
> another sentence after this, I am in trouble too ...
>        because I can't write a sentence like this: 'Create Date' >
> "01/01/2007" AND 'Status' < 3 ...
>
>
>        Any suggestion will be appreciated!
>
>        Att,
>
>
>        Tadeu Augusto Dutra Pinto
>        -----------------------------------------------------------------
>        IT Web Services ATM
>        Cinq Technologies
>        http://www.cinq.com.br <http://www.cinq.com.br/>
>        [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>        Fone: 41 3018-2833 - Cinq
>        Fone: 41 2107-5736 - HSBC Outsourcing
>        -----------------------------------------------------------------
>        Confiabilidade, Inovação e Qualidade em T.I.
>
>        ________________________________
>
>        De: Action Request System discussion list(ARSList) em nome de Joe
> D'Souza
>        Enviada: sex 4/4/2008 14:06
>        Para: [email protected]
>        Assunto: Re: Using 'Search Bar' with 'Create Date'
>
>
>        **
>        Just a guess but by the time your statement is evaluated, maybe the
> ARS translates 'Create Date' to '3'??
>
>        Did you check the AL logs assuming your workflow is AL based?
>
>        Joe
>
>               -----Original Message-----
>               From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto
>               Sent: Friday, April 04, 2008 11:41 AM
>               To: [email protected]
>               Subject: Using 'Search Bar' with 'Create Date'
>
>
>               **
>               Hi for all,
>
>               I'd like to know if there is a way to block users to do
> sentences like that:
>               'Create Date' < "0404/2008" for example...
>
>
>               I tried to do something like this... 'Search Bar' LIKE ((
> "%"  +  "'Create Date' <" ) +  "%" )
>               using Active Link...
>
>               But it does not work ....
>
>
>               Thankx in advance...
>
>
>               Tadeu Augusto Dutra Pinto
>
>               
> -----------------------------------------------------------------
>               IT Web Services ATM
>               Cinq Technologies
>               http://www.cinq.com.br <http://www.cinq.com.br/>  <
> https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/
> >
>               [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>               Fone: 41 3018-2833 - Cinq
>               Fone: 41 2107-5736 - HSBC Outsourcing
>
>               
> -----------------------------------------------------------------
>               Confiabilidade, Inovação e Qualidade em T.I.
>
>        __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/>  
> ARSlist:
> "Where the Answers Are" html___
>
>
> _______________________________________________________________________________
>        UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <
> http://www.arslist.org/>
>        Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/>  
> ARSlist:
> "Where the Answers Are"
>
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to