7 Replies Latest reply on Aug 22, 2016 12:53 PM by philipHPG

    Calculate a list of whole numbers between two variables?


      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?