What would be the best way to use Tinderbox to track time? Subscribing dates does not calculate an interval, but rather a number of the days difference. I’d like to be able to subtract an EndDate from and StartDate and get the numbers of hours difference with as minimal overhead on Tinderbox as possible. Do I need to create StartTime and EndTime attributes and calculate these first? Ah, so many questions. Does anyone have any thoughts?
What you want is interval(start,end), which returns the interval between two times.
Did you try the hours(date1,date2) operator:
returns the Number of whole hours that elapsed between date1 and date2. If date2 is earlier than date1 then the result is negative.