Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DATEDIFF within IF

Please could someone tell me why this doesn't work?   =if([status]="Closed", DATEDIFF([date_entered],[date_closed],DAY), "Not Closed" )   I wish to calculate the number of days between the dat...