Associated Items
List Search

Time and Date Functions (2/2)

Simply parsing out the values from a given field is useful, however, some of the other important Date and Time formulas that Infowise provides for us can do more customizable tasks such as calculate the difference between two date columns.


In this example, we will use the same Projects list from part one with the Project Start and Project End Columns to test these formulas.

 Just like before, our first step is to create an output field for our formula to populate to. Navigate to your List Settings page and create a Single line of text column titled ‘Length of Project’ for each of the four formulas we want to test. You will end up with the following:

Length of Project Seconds

Length of Project Minutes

Length of Project Hours

Length of Project Days

Next, navigate back to your Infowise Design Screen and to the Actions page inside the Configure Business Logic section. Leave the default Action type of Update list item and give your action a descriptive name. Similar to before, we need to test this action manually so uncheck all of the Run-on events at the bottom of the tab.

Now, lets move to the Advanced Settings tab and select the Execute action through context menu or ribbon button. Since we now have more than one action on this list running through the ribbon, go ahead and select a different icon as well.

Now move onto the Action Settings tab where we will be inputting our formulas:

$Days([Project Start]|[Project End])

$Seconds([Project Start]|[Project End])

$Hours([Project Start]|[Project End])

$Minutes([Project Start]|[Project End])


Click Add after each formula input. Notice that there is a 's' at the end of these keywords and also that they take two parameters. Your finished Action Settings tab should look similar to below: 

No conditions are necessary but remember to save your action.

Navigate back to your list to test the actions we just built. Select some amount of records and then click Run Actions from the Items tab above.


Select the Length of Project action from the pop-up window that appears. Click the icon and wait for Infowise to complete its calculations.


Infowise will again take some time to calculate each of these values for us and we will be left with a list similar to the picture below.



In this example, we discussed the Infowise date functions that can be used to find the difference between DateTime columns. This information is invaluable for project tracking and reporting purposes!

Last modified: 10/2/2018 6:45 PM

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.
Infowise logo
© 2005-2021 Infowise Solutions Ltd
Microsoft partner logo
GSA Schedule
Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.