cancerjenn
MIS
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!
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!