Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.

Welcome to Nintex Connect Sign in | Join | Help

Home

Forums

Downloads

Nintex Connect » Nintex Workflow 2007 » Developer Information » Query list filtered by datetime values

Query list filtered by datetime values

Last post 08-22-2010, 10:15 PM by Peter D. 1 replies.


	Sort Posts: Previous Next

08-20-2010, 2:05 AM 12515

Matteo Maglio
Joined on 07-24-2009
Posts 20

Query list filtered by datetime values

Reply Quote

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!