Forum Discussion
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...
JorgePinho
Solution Sage
Solution SageIs that a measure or a new column?
If it is a measure you have to use something like: DATEDIFF(MAX([date_entered]),MAX([date_closed]),DAY)