Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

date comparision based on user entry

I have to compare 2 dates and get the result

User will enter the Date1  : 02/05/2018

                                                                 

EntryDate  DueDate Name

01/05/18 02/03/18 aaaaa

01/06/18 02/06/18 bbbb

01/15/18 05/20/18 cccc

01/30/18 06/06/18 ddddd

02/02/18 08/07/18 eeee

02/04/18 06/22/18 fffff

03/06/18 05/02/18 dsesd

05/06/18 09/09/18 mmmm

05/23/18 01/04/19 rrrrrr

06/22/18 04/04/19 ttttttt

06/25/18 09/09/20 ssssss

I have to find which name belongs to this below condition if the user enter the  Date1  : 02/05/2018

         

Entry Date <= Date 1 

Due Date >= Date 1 

                  

what is the best way to handle.I tried with Getfield selection for capturing the user entry and compare the values .It didn't work.

Advance Thanks for your help.

1 Reply
Anil_Babu_Samineni

GetFieldSelection() Work only when some selections selected. Where USER is entering?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)