sunnychu

Execute SQL comparing dates

Discussion created by sunnychu on Jan 16, 2016
Latest reply on Jan 16, 2016 by jbrown

Hi I am writing this ExecuteSQL() command but it somehow doesn't work

 

ExecuteSQL (

"

 

SELECT SUM(a.Plan_SoupToDeliver)

FROM Proc_BatchLine a INNER JOIN Proc_Batch b

ON a.fk_DeliveryBatch = b.pk_DeliveryBatch

WHERE b.Date = ?

 

"

; "" ; "" ; _HOME::TargetBatchDate

)

 

_HOME::TargetBatchDate is a date field

 

I tried removing the WHERE and it will work perfectly fine.

Is it something to do with FileMaker not being able to compare date field with SQL format?

 

Thanks in advance

Sunny

Outcomes