Calculate a list of whole numbers between two variables?

Discussion created by jrobgk1 on Aug 10, 2016
Latest reply on Aug 22, 2016 by philipHPG

Hi there-

I am working on an "availability" table for my solution. The idea is that a contractor will tell us what time they are available to work on a given day (e.g. 4PM - 11PM). I would like to take the result of those two dates (which would be created in Available::TimeStart and Available::TimeEnd fields).


I would like to create a list of hours that they are available (in this case, 4,5,6,7,8,9,10) that could then be used to create individual records in a related table (HoursAvailable) allowing that person to be scheduled based on the main calendar.


Does the community have any thoughts on ways to approach this?