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

Query list filtered by datetime values

  •  08-20-2010, 2:05 AM

    Query list filtered by datetime values

    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!

View Complete Thread
Powered by Community Server, by Telligent Systems