I need to compute the number of days between the startdate and the enddate. (how many days between two dates input in apps aka the duration of using a spare part)
At first, I was wrongly using an expression : DAY([EndDate]) - DAY([StartDate]) , returns the difference between the day number. So I searched from the doc, found the expression example there.
Honestly, I didn’t try the long expression from the doc. Confused with the [Years] and [Months] as said to be Virtual Columns there. I try : FLOOR(HOUR([EndDate] - [StartDate])/24) , the outcome is exactly what I’m looking for. So I wondered is there anything that I should know about that long expression.