>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]
