AnsweredAssumed Answered

How do I perform a query list search to retrieve records from inbetween DATE/TIME X to DATE/TIME Y

Question asked by kterns on Jun 30, 2015
Latest reply on Jun 22, 2018 by murphybp2

When I perform an "Action - Query list" to gather items from a list and then filter on Start Date for between two DATE/TIMES, the query ignores the time stamp and provides items from the entire date from 12:00AM - 11:59PM.  I can't seem to distinguish items based on the full DATE & TIMESTAMP, though that information is there in the field and is reporting.

 

 

For reference (calculated variables - both DATE/TIME variables defaulted to Blank)

 

This workflow runs weekdays at 7am.

Workflow has History log in several spots and all variables for DATE/TIME are returning the DATE & TIME correctly throughout the entire workflow process.

 

Thanks for the time!  This has been stumping me for a while.

Outcomes