thank you very much,

>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