Filemaker 12 Windows 7
ExecuteSQL ("SELECT mcStockCode , Qty , ExtValue , mcDateSupplied
WHERE mcDateSupplied BETWEEN ? AND ?";"|";"";
This query is only returning items with date 01/01/2012 to 05/01/2012 87 items instead of 598 items
I have checked the date format is the same in the database ie / and not dots .
If I change the date in the data to ALL show 01/05/2012 (ore before) they are picked up
If I get all to be 06/01/2012 or later none show
I have also tried adding DATE (mcDateSupplied) still does not work what am I missing please?
I have also tried mcDateSupplied > 31/12/2011 AND mcDateSupplied < 01/02/2012
Actually used Greater than OR Equal to but dont know how to type that
Thanks in anticipation