filemaker@i-absolute.com

ExecuteSQL and BETWEEN

Discussion created by filemaker@i-absolute.com on Dec 2, 2014
Latest reply on Dec 2, 2014 by filemaker@i-absolute.com

Hello everyone, I would like to get the sum of column A, where my search value is between column B and column C.

I tried it with this query, but does not seem to work properly:

 

 

SELECT SUM (T.columnA) FROM T WHERE ? BETWEEN T.columnB AND T.columnC

 

 

T.columnA, T.columnB and T.columnC are INT

ie. ? = Year (Get (currentDate))

 

 

thanks,

Fabio

Outcomes