I'm trying to calculate the date/day difference between order creation and close dates. The problem is that not all the orders in the table are done, so not all rows have a close date. That makes daydiff to return an error.
How can i include a conditional rule in the daydiff custom field so i can rule out the rows with no close date?
I tried something like IfDateTime([Converted_at_day], DayDiff([Converted_at_day],[created_at_day]), 0) with no success.
Any help would be appreciated. Thank you!
Please sign in to leave a comment.