Date difference and formula in the report

Question

Good afternoon, the formula does not work https://prnt.sc/CQEjC1TsbxZo
I am building a formula to understand how many days the lead was in work before closing
BUT it does not accept variables from the list, and there is no closing date option. Where can I get this variable?
1 You can check what does not take date from variables
2 Please give the value of the closing date for the formula
And by the way, in the process procedure, calculating the date difference, there is also no option for the closing date

Answer 1

Мария

OneBox production

Good afternoon
You specified the variable a little incorrectly and because of this, the data from the field was not taken, it was necessary not [orderdateplan] but [dateplan]
Difference formula between closing date and creation date: diffDay([dateclosed], [cdate])

Make a payment (donate)

17.08.2023, 13:33

Original comment available on version: ru

Date difference and formula in the report

Answers:

Thanks for your choice.