Hi I am working on a report where I want to find how many new customers each month so my Select Record is as follows
{ORDERHDR.OPERATOR} <> "NW" and
{ORDERHDR.ORDER_DT} in {?Starting Date} to {?Ending Date} and
not {ORDERHDR.PROFORMA} and
not {ORDERHDR.CANCELLED} and
not {ORDERHDR.TEMPSAVE} and
{CUST.FIRST_DATE} in {?Starting Date} to {?Ending Date}
I need the CUST.FIRST_DATE TO BE EQUAL TO THE ORDERHDR.ORDER_DT - I seem to be getting mixed data with the selection I am using, one account that shows up has a first order date of 2003. I tried it with just using the CUST.FIRST.DATE but that gave me extra data too. Is there a better way to approach this? Any suggestions would be appreciated. Thanks
{ORDERHDR.OPERATOR} <> "NW" and
{ORDERHDR.ORDER_DT} in {?Starting Date} to {?Ending Date} and
not {ORDERHDR.PROFORMA} and
not {ORDERHDR.CANCELLED} and
not {ORDERHDR.TEMPSAVE} and
{CUST.FIRST_DATE} in {?Starting Date} to {?Ending Date}
I need the CUST.FIRST_DATE TO BE EQUAL TO THE ORDERHDR.ORDER_DT - I seem to be getting mixed data with the selection I am using, one account that shows up has a first order date of 2003. I tried it with just using the CUST.FIRST.DATE but that gave me extra data too. Is there a better way to approach this? Any suggestions would be appreciated. Thanks