Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter on DateTime field using 2 Input Fields as Start and End Dates

I have implemented a logic to filter on a DateTime field by using 2 input fields billed as Delivery Date From and To Dates. Each Input field is tied to a variable which triggers the DateTime Field onChange of the variable.

This is working fine when I filter for records where the time the hour is either 10, 11 or 12. But not the case for single hours like 1 through 9.

Is this a possible bug or am I missing on something ?

Attaching the document for reference.

Try inputting the following -

From Date - 4/1/2010 12:30:36 AM

To Date - 4/1/2010 12:31:36 AM

You get 3 records.

Change the To Date to 2:30:38 AM and it doesn't retrieve the 7 records. Bug ?

0 Replies