Select Page

A new knowledge base article has been published on our support portal.

## Scenario

Below we have listed examples of the TimeRangeGetRelation() function to help you understand how to use it.

Each example has their result in comments.

## Formula

``````Smartflow(

TimeRangeGetRelation(CreateDate('2018','1','10'), CreateDate('2018','1','15'), CreateDate('2018','1','1'), CreateDate('2018','1','8')), /* Returns After */

TimeRangeGetRelation(CreateDate('2018','1','10'), CreateDate('2018','1','15'), CreateDate('2018','1','1'), CreateDate('2018','1','10')), /* Returns Start Touching */

TimeRangeGetRelation(CreateDate('2018','1','10'), CreateDate('2018','1','15'), CreateDate('2018','1','1'), CreateDate('2018','1','12')), /* Returns Start Inside */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','1'), CreateDate('2018','1','15')), /* Returns Inside Start Touching */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','1'), CreateDate('2018','1','8')), /* Returns Enclosing Start Touching */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','3'), CreateDate('2018','1','8')), /* Returns Enclosing */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','3'), CreateDate('2018','1','10')), /* Returns Enclosing End Touching */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','1'), CreateDate('2018','1','10')), /* Returns Exact Match */

TimeRangeGetRelation(CreateDate('2018','1','5'), CreateDate('2018','1','10'), CreateDate('2018','1','1'), CreateDate('2018','1','15')), /* Returns Inside */

TimeRangeGetRelation(CreateDate('2018','1','5'), CreateDate('2018','1','10'), CreateDate('2018','1','3'), CreateDate('2018','1','10')), /* Returns Inside End Touching */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','8'), CreateDate('2018','1','15')), /* Returns End Inside */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','10'), CreateDate('2018','1','15')), /* Returns End Touching */

TimeRangeGetRelation(CreateDate('2018','1','1'), CreateDate('2018','1','10'), CreateDate('2018','1','12'), CreateDate('2018','1','15')) /* Returns Before */

)``````