Selection formula

[grierfield]

With this formula I am trying to select all the {bl_exp.PURPOSE} fields that have a “Q” or “P” for the year 2003. however for some reason the selection is not being limited to year 2003, i am getting the P and Q for 1995, 1996 … thru 2003. what is wrong with the formula below that I am using?

{bl_exp.D_EXP} > Date (1995, 12, 31) and
{bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q"

 

[bburnell]

Try this:

({bl_exp.D_EXP} > Date (2002, 12, 31)) and
({bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q&quot

Hope that helps!
Brett (smsforce)


--------------------------
Please visit my website!

http://www.smsforce.com

 

[synapsevampire]

The formula says greater than 1995, why are you expecting > 2002?

Select Report->Edit Selection Formula->Record and place something like:

{bl_exp.D_EXP} > Date (2002, 12, 31) and
{bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q"

-k

 

[vidru]

You need parentheses after the 'and' to group your two 'or' conditions. Try this instead:

bl_exp.D_EXP} >= Date (2003, 1, 1) and
({bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q")

 

[bburnell]

If I'm not mistaken, you will still have to use the parenthesis or the formula will look for:
date > 12/31/02 and purpose='P'
-or-
purpose='Q' (no date specified)

I could be wrong, but better safe than sorry!
Brett (smsforce)

--------------------------
Please visit my website!

http://www.smsforce.com

 

[grierfield]

-k, the formula actually says >Date(2002,12,31) and not > Date(1995, 12, 31) as I posted, the actual formula is as shown below, THANX

{bl_exp.D_EXP} > Date (2002, 12, 31) and
{bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q"

 

[bburnell]

Use the formula exactly as it's shown in my first reply and that should fix it.
Brett (smsforce)

--------------------------
Please visit my website!

http://www.smsforce.com

 

[grierfield]

Thanks Brett, the parenthesis made the difference,
Grier.

({bl_exp.D_EXP} > Date (2002, 12, 31)) and
({bl_exp.PURPOSE} = "P" or {bl_exp.PURPOSE} = "Q&quot