Malformed statement erro

[moshood]

Hi Community, 

can anyone tell me why i am getting this error "Malformed IF Statement" and Parse error at Char

[fmvizcaino · Accepted solution]

Hi @moshood ,

You only need to delete the highlighted area from the image below.

Best,

Fernando Vizcaino

[moshood]

Thank you this has worked. 

are you able to explain why this part did not work because i have a similar formula (attached) that has worked?

Thanks you  

[fmvizcaino]

Hi @moshood ,

The formula attached looks like the one we just corrected. The problem with your first formula was that you were doubling the parameter for datetimeadd adding days with lease start date and then subtracting 2.

Best,

Fernando Vizcaino