Re: Filter operation
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: Alex Fatkulin <afatkulin@xxxxxxxxx>
- Date: Tue, 23 Mar 2010 23:12:09 +0100
ok, got your point : )
Thanks!
--
LSC
On Tue, Mar 23, 2010 at 6:16 PM, Alex Fatkulin <afatkulin@xxxxxxxxx> wrote:
> "dont understand very well why those two conditions why will always
> results in FALSE?"
>
> I never said that they will. Please look and read more carefully and
> you'll see that the predicate which I've used is the opposite to what
> you really have.
>
> On Tue, Mar 23, 2010 at 1:00 PM, LS Cheng <exriscer@xxxxxxxxx> wrote:
> > Hi Alex
> >
> > dont understand very well why those two conditions why will always
> results
> > in FALSE?
> >
> > I have two FILTER operations
> >
> >
> > 2 -
> > filter(ADD_MONTHS(TRUNC(SYSDATE@!,'fmmm'),-1)<TRUNC(SYSDATE@!,'fmmm'))
> > 4 - filter("MF"."F_PERIOD">=ADD_MONTHS(TRUNC(SYSDATE@!,'fmmm'),-1)
> AND
> > "MF"."F_PERIOD"<TRUNC(SYSDATE@!,'fmmm'))
> >
> > For step 4 I understand that Filter is requiered but step 2....
> >
> >
> >
> > Thanks!
> >
> > --
> > LSC
> >
> > On Tue, Mar 23, 2010 at 5:09 PM, Alex Fatkulin <afatkulin@xxxxxxxxx>
> wrote:
> >>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
>
Other related posts:
