Associated Items
List Search

Today field date comparisons

With a dynamically updating Today field, you can use calculated fields to make date comparisons.
These comparisons are critical to setting up other smart actions and KPI indicators on the dashboard.
This example describes the simple process of getting the difference between two dates using a SharePoint calculated field.


  • In your list settings create a standard SharePoint date and time field named Due Date.
  • Set the field as required and otherwise use default settings.
  • Create a standard SharePoint calculated field named Date Difference:

  • Simply subtract the Due Date value from your Today field value as shown.
  • Note that a negative value is good in this example and a positive value means overdue:


Tracking and comparing dates is valuable part of the recipe when it comes to building productive tools in SharePoint. Because your date comparisons will update each day, dashboards become dynamic and users will be able to quickly identify which projects are not on schedule. In more sophisticated tools, there may be a need to do many date comparisons as triggers for multiple workflows running in your custom tool.

Last modified: 9/1/2017 5:47 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.