Problem with Iff

[007700]

Hi there,

Could anyone tell me what is wrong with the following statement ? I don't seem to be able to find it....

iff((([Eind maand]-[Instalatie_datum]-[aantal_dagen_deze _maand])+1)<=0,"true", "false")

 

[PHV]

IIf (not iff)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

try this:

iif(([Eind maand]-[Instalatie_datum]-[aantal_dagen_deze _maand])+1 <= 0, "True", "False")

Leslie

 

[007700]

Well it keeps op giving me #Name? as result..... and I can't seem to find out how to fix it..

 

[jbpez]

Describe each field and where is this function located.

John Borges

 

[ZmrAbdulla]

Thread has been split into two, please see thread702-998175

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me