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