Re: Query list filtered by datetime values

Peter D — Mon, 23 Aug 2010 05:15:45 GMT

Please see this post: http://connect.nintex.com/forums/thread/1222.aspx.

Query list filtered by datetime values

Matteo Maglio — Fri, 20 Aug 2010 09:05:26 GMT

Hi,

I've added a Query list Action to a workflow to have the items of a list filtered by a datetime value (this value must be between 2 others datetime field of the item list) but the filter doesn't consider the time of the date. For example:

"20/08/2010 7:52" between "19/08/2010 0:00" and "20/08/2010 10:00" --> item appears in the result of the query (correct)

"20/08/2010 7:52" between "19/08/2010 0:00" and "19/08/2010 10:00" --> item doesn't appear in the result of the query (correct)

"20/08/2010 7:52" between "19/08/2010 0:00" and "20/08/2010 07:00" --> item appears in the result of the query (ERROR!)

How can I obtain the correct result of the query?

Thanks!

Developer Information

Re: Query list filtered by datetime values

Query list filtered by datetime values