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 ?";"|";"";

"01/01/2012";

"31/01/2012")

 

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

 

Cathy

Outcomes