Date and Time calculation

Fusion can dynamically do just about any type of calculation on Date,Time and DateTime data types.

This example will add one minute to the DateTime value assigned to the [Modified] column in a SharePoint Library

The syntax:
DateTime( Date( DateTime([data]) ), RelativeTime (Time(DateTime([data])) , 60))

The value passed in [data] is the value assinged to the. You can also reference columns directly by name or use parameters. as part of the calculations.

*Tip. You can paste a function by r-clicking. Detailed Online-Help is available to all functions, just r-click on the function and select Help.

*Advanced: You can have multiple steps in your calculation if you use Rules. Multiple expressions can be mixed with one or more standard rules.