Getting an error in expression in if condition

[tdiwanji]

Hi,

I am trying to find out following.

if End date is not null, then end date - start date+1 else today-start date. While doing so, i am getting error in expression error. Would anyone help me to resolve ?

=if((not isnull[End_date],
[End_date]-[Start_date]+1), today()-[Start_date])

[Channa]

=if(not isnull([End_date]),([End_date]-date([Start_date],1)), today()-[Start_date])

try

[jonathandienst]

You can simplify the expression like this:

=Alt([End_date] + 1, Today()) - [Start_date]