AnsweredAssumed Answered

AND Calculations

Question asked by Marty1 on Sep 26, 2010
Latest reply on Sep 27, 2010 by Marty1

Title

AND Calculations

Post

Hi,

I am having dificulty to write a calculation using the AND function, (if that is what I should be using)

I am trying to find a certain product number that apprear on any invoices between certain dates.

I have a field 'product_num' and 2 global fields 'date_low' & 'date_high_

I have  a script to find the invoices with that product - it is.....

Enter Find Mode []

Insert Calculated Result [Select; Lines_Cust_Inv::product_num; '=' & globals::x_product_num]

Perform Find []

__________________

The script to find the invoices between the dates, I have as....

Enter Find Mode []

Insert Calculated Result [Select; Lines_Cust_Inv::Date; ">" & Globals::date_low & "<" & Globals::date_high]

Perform Find []

____________________

Please can you help with the syntax (or another way) to find the products with a specific part number invoices between specific dates.

Many thanks in advance

Marty

Outcomes