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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot search for a specific year in a date text box (only month)

Hi,

I have a classical text box with a field date in it. The original format is date so like 45535. In the text box, I put a format date (YYYY/MM/DD) and when searching in the text box, only the month are searched....

So if I type 2, only the date with 2 in the month is selected but not the year starting by 2.... Typing 2012 will give me no result...

I tried to change the date format to YYYYMMDD ou YYYY_MM_DD but no luck....

Thanks in advance for your help!

14 Replies
ashwanin
Specialist
Specialist

Can you post a sample file for checking

Not applicable
Author

Here it is. I just upload a few fields.

You can see that you cannot search by date ie typing any figure will show me no result.

Thanks

ashwanin
Specialist
Specialist

hi use this in your script :

date(date#(DateName, 'YYYYMMDD'), 'DD-MM-YYYY') AS DateName1

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You have two options - change the Default Search Mode (Properties  | General for the list box) to 'Use Wildcard Search' or type in the wildcards yourself. For example *3*  returns values with 3 anywhere in the date.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan!

didn't know about the the wildcard... I'm usually searching for text so I guess the wildcard is not needed but for number it's great!

Thanks again for your help