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?