Improved handling of Today function
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.
Add your comment
100% No-Code Solution
It's never been easier, to create, innovate and share, all you need is your web browser!
Address business process pain points immediately. Save time and money.
Fantastic Support Team
Facing difficulties installing the application? Contact our fantastic support team.