AnsweredAssumed Answered

sql DATE problems

Question asked by Gingernut on Nov 20, 2012
Latest reply on Feb 18, 2013 by novarem

Filemaker 12 Windows 7


ExecuteSQL ("SELECT mcStockCode , Qty , ExtValue , mcDateSupplied

FROM ConsumablesPartsFitted

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