Between can be used as a function

?BETWEEN(1,0,2)

or as a operator in SQL Where

SELECT Cur1.BlahBlah FROM MyCursor AS Cur1 WHERE Cur1.SomeField BETWEEN Start_Range AND End_Range

You need a function:

SELECT *, IIF(BETWEEN(edate , DATE() , GOMONTH(DATE(),+1)),1,0) AS limit,; 
GOMONTH(DATE(),+1) - edate As Daysleft FROM Master WHERE edate >=DATE()

>thank yoy fro reply,
>Wrong syntax for BETWEEN, You nned to use a BETWEEN() function in IIF, not the SQL operator?? ihave no idea
>
>help again to fix it,
>
>thanks alot
>
>>>hi all,
>>>
>>>i get error message missing comma(,)
>>>
>>>

>>>SELECT *, IIF(edate BETWEEN DATE() AND GOMONTH(DATE(),+1),1,0) AS limit,; 
>>> GOMONTH(DATE(),+1) - edate As Daysleft FROM Master WHERE edate >=DATE()
>>>

>>>thanks
>>
>>Wrong syntax for BETWEEN, You nned to use a BETWEEN() function in IIF, not the SQL operator.
>>
>>Agnes