From the example in Date and Time Expressions : Examples that compute duration in days, months and years
FLOOR(((HOUR([EndDate] - [StartDate])) - (([Years] * 365.24 * 24.0) + ([Months] * 30.4 * 24.0))) / 24.0)
Question :
What is the difference from :
FLOOR(HOUR([EndDate] - [StartDate])/24)
since i got the same result.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |