Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgandhi715
Contributor III
Contributor III

Select two dates from one column using a button


Hi,

I want to select all dates  between the dates selected by user. I have added two calendar objects and have used two variables to get the From and To date selected by the user. I have a button "Commit" on click of this button i want to select all the dates between these two dates. The expression i have written was working fine till the time i changed the date format in the load process.

The date format I am using is "DD-MMM-YYYY"

The expression i am using is

='>=' & Date(vFromDate, 'DD-MM-YYYY') & '<=' & Date(vToDate, 'DD-MM-YYYY')

Is it the problem with the format of the date? or is there something that i am missing?

Any response is greatly appreciated.

Thanks in advance.

Nikhil.

10 Replies
Anonymous
Not applicable

No problem whiteline, I know it's just  a typo