Views:

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 */


)

 

Did you know?

North52's Data Packager helps move configuration data between instances

North52 Data Packager is an add-on for North52 Business Process Activities which enables you to easily move data from one instance to another.  Users simply select the records they would like to package up and North52 Data Packager adds the data to a data package sheet, ready for export. Moving the records to another instance requires the package solution to be imported and ‘unpacked’ on the target instance.

North52 Data Packager is ideal for:

  • Moving Dynamics configuration records
  • Copying Dynamics Portal records
  • Distributing demonstration data

Learn more about the North52 Data Packager

Keywords: Smartflow, CreateDate, TimeRangeGetRelation, SmartFlow, Formula Manager