>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
>
Instead of:
... IIF(edate BETWEEN DATE() AND GOMONTH(DATE(),+1),1,0)
use
... IIF(BETWEEN(edate, DATE(), GOMONTH(DATE(), 1),1,0)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.