NEED HELP WITH Selecting records

[cancerjenn]

well, here is my issue. I'm pulling records out of this database in crystal report8.5 and i need show the prices of items that hasnt been updated w/o the effective date 5/1/02. For example,
Old List before sort
123 1/1/00 New List after sort
123 3/1/02 =========== 345 5/1/00
123 5/1/02 678 2/1/00
456 1/1/00
456 5/1/02
345 1/1/00
678 2/1/00

So the formula for it should be something simliar to the below:
{F4102.IBMCU} = " 9500" and
not ({@DATE} in [DateTime (2002, 05, 01, 00, 00, 00)])

Is that right? Let me know. THANKS!

 

[bjrollet]

Why don't you try it, and let US know.

 

[cancerjenn]

I did already !What i meant to say was "am i close?" anyways, u r really rude! U must be really young! uh?

 

[bjrollet]

First, I am 29 yaers old, have been programming for 5 years, and I was not being rude. Your original post said nothing of the fact that you had actually tried the formula you listed. It appears as though you are asking for someone else to do the work for you. If you tried it already, than you should know if it works or not. You shouldn't ask if you are close, how is anyone supposed to know that? Especially if your question is a complex one that requires some knowledge of the original report and data. It either works or it doesn't. Be more specific.

 

[synapsevampire]

Now, now, no hitting biting scratching or hitting below the belt, or I'll post a really lengthy dissertation on the desocialization of us geekish sorts

As you can see from your post, the data you supplied didn't come across well, but I might have an idea of what you want:

{F4102.IBMCU} = " 9500" and
not ({@DATE} in [DateTime (2002, 05, 01, 00, 00, 00)])

Try changing this to:

{F4102.IBMCU} = " 9500" and
not ({@DATE} = date(2002, 05, 01))

You were passing a specific time as your criteria, which would likely return all rows still.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cancerjenn]

well, thanks! synapsevampire

 

[cancerjenn]

Yo! bjrollet,

you really need to grow up!