AnsweredAssumed Answered

Site workflow to query list for items within time range not working anymore

Question asked by yvette on Jan 14, 2019
Latest reply on Jan 15, 2019 by N M

I have a site workflow that runs on the first of every month. It calculates the end of this month and saves it to a date variable. Then it queries the list to see if there are any items that fall within the date range of the current date and the end of the month.

 

Seems simple enough. This set-up used to work perfectly but now returns zero results.

 

Configuration:

The column "Start datum" is a date column - no time included. My query is as follows: Select items if "Start datum" is bigger than or equal to current date AND select items when "Start date" is smaller than or equal to "End of the month" variable.

 

There are in fact items in the list with start dates for January.

 

I did some further testing. If I query an Id directly, I get the following "Start datum" output:

 

If I then query the list for items equal to 1-1-2019 or 1-1-2019 00:00:00 exactly I get the same outcome: no results found. This leads me to believe it doesn't have anything to do with a change in time formats (possibly the result of an update?) or something.

 

Your help would be much appreciated!

Outcomes