3 Replies Latest reply: Feb 11, 2015 2:08 PM by Vinay Bangari RSS

    interval match and peek

      The client is a sewing machines institution. The client would like access dashboard to be able to analyze what is the end date and capability sewing machines are available at a particular day. To facilitate this client has provided records of recent database of sewing machine availability. Each database has information about hour’s sewing machine available, workspace, start date and end date.

      Here is the respective data, workspace AA is allocated for 100 minutes from 1/1/2014 to 1/12/2014 and 200 minutes from 1/14/2014 to 1/24/2014. Workspace BB is allocated for 100 minutes from 1/8/2014 to 1/17/2014 and 200 minutes from 1/19/2014 to 1/24/2014.