Question

Does Update multiple items using filter of date and time does not work?

  • 17 January 2023
  • 0 replies
  • 8 views

Badge

Hello!

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:

  1. Is this a known limitation of Nintex for SharePoint 2019?
  2. 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).

 

Screenshot:

 

Best regards,

Stefan


0 replies

Be the first to reply!

Reply