Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful