I have an issue. I need to create a tab for tasks where the manager will assign tasks to employees. I saw that the correct field type to use would be a date range, but I also need to calculate the difference between the end time and the start time. However, I’m not able to calculate this difference because the data type returned is calendar and not date. I believe that’s why the calculation isn’t working. Can anyone give me some guidance on how to solve this? I’ve already tried converting the start date from calendar to date, but I can’t seem to get it right — maybe I’m not doing it correctly.
