Improved handling of Today function

Vladi Gubler
Vladi Gubler
September 06, 2017 | General

Hi,

In actions, you can add a condition to compare a date column to [Today] function, such as Created equals [Today]. But date columns in SharePoint contain not just the date, but the hour part as well. [Today] function returns time as 00:00 or 12:00 AM (midnight), so when your date column is not exactly set to midnight (let's say the item was created at 4:00 PM), the condition will not be valid, as the dates don't exactly match. You could create two conditions, such as:

  • Created >=[Today]
  • And Created < [Today]+1

But it looks a bit complicated and could lead to confusion and errors.

We decided to make your life easier. Now, when we see an equals or not equals comparison of a date column to a value containing [Today] function, we will add those two condition implicitly in the background. So now all you have to do it simply use the "equals" (or "not equals") operator, and we will take care of the rest. This new functionality is now available for Actions in the app version and will soon be implemented on-premises as well.

Loading...

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.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics


© 2019 - Infowise Solutions Ltd
The awesome power of ULTIMATEforms

Quickly and easily turn time-consuming business processes into automated, efficient workflows.

100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com
 Yes, send me Infowise Newsletter.

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.

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.