I have a field which is the result in days between 2 date fields.
The formula I use is: field(‘Date départ’) - field(‘Date arrivée’)
It returns a “Date interval” in days.
In another field I need to multiply these days by a daily fee to get an amount to pay for the customer.
When I try to use the function “tonumber” to convert the date interval into a number I have a message saying it doesn’t work because tonumber only converts text to numbers.
How can I convert this date interval to a number to be able to multiply it with a fee (which is a number already)?