I just want the end user to be able to select between two (order_date) dates via a parameter in CR2K8.
I am not sure why the date field is coming over as a string and I guess this could be the reason why my parameters aren't working. I can make the parameters, but it still grabs everything in the database. Any help would be appreciated.
SELECT order_date, cust_code, cust_po, shipto_code, part_code, qty
WHERE (statflg = 'm') AND (notes3 = 'ITEM MARKED AS PROCESSED')