AnsweredAssumed Answered

When filter data from a SharePoint List on Modified, has anyone had a problem where time is not being compared?

Question asked by sonisick on Feb 9, 2017
Latest reply on Feb 13, 2017 by emha

I've just experienced a problem comparing two dates and times on a SharePoint List, one of them is the built-in Modified column. The other column is one I built with Nintex that I ensured had a time component.  I know the Modified in SharePoint has a time component because you can see such listings as "1 minute ago", "two hours ago".

 

When I go to compare these in a Query List Item, the Item only returns the result I feel should be returned if the Date of the column I specified is before today.  If I specify a date several hours less than the Modified Date, the query will not return any items--even though I know they are present. It ONLY seems to be doing a DAY compare.

 

I would like to only update if something changes. I don't want to resort to flags and updating flags.

Anyone seen this type of behavior?

 

Outcomes