I would like to update multiple items which are filtered by a date/time column in the list so that I only get the items where the date/time column is set to a timestamp before now.
As you can see in the screenshot attached (sorry, it’s German), I calculate a date (current date with current time) and put it to a workflow variable (v_DateTime_date and v_DateTime_txt).
After that I would like to update multiple items where the column “Datum bis” is before v_DateTime_date.
It looks like that the filter checks only the date but not the time. Elements, where the column “Datum bis” is set to a timestamp before today, are found and updated.
Elements, where the column “Datum bis” is set to a timestamp earlier on the current day, are not found and not updated.
So my questions are:
- Is this a known limitation of Nintex for SharePoint 2019?
- Is there a different way to achieve the descripted goal? Any hints?
By the way: It seems that delete multiple items acts in a different way and the time is also taken in account by the filter (but I can not proof it yet).