topic Re: Cannot search for a specific year in a date text box (only month) in QlikView

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

Tue, 18 Mar 2014 10:37:57 GMT

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!

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

ashwanin — Tue, 18 Mar 2014 11:06:22 GMT

Change date format at Script level by

Date ( FiledName,'DD-MMM-YYYY') as FieldName

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

Tue, 18 Mar 2014 11:21:19 GMT

Hi,

Change the Date Format at Document Setting --> Number .It works, I had similar kind of issue.

Thank you.

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

Tue, 18 Mar 2014 11:23:17 GMT

Thanks I'm trying it....

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

Tue, 18 Mar 2014 11:26:59 GMT

Thanks but if I put number my date will look like 45532, 45533,.... so it's not usable

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

Tue, 18 Mar 2014 11:29:05 GMT

Under Number Tab, change the format as Data.

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

Tue, 18 Mar 2014 11:44:07 GMT

I tried it's not working.

Thanks

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

sunilkumarqv — Tue, 18 Mar 2014 11:45:52 GMT

TRY THIS AT YOUR SCRIPT

=date(date#(DateStringField, 'YYYY-MM-DD'), 'DD-MM-YYYY') AS DateField

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

Tue, 18 Mar 2014 11:53:59 GMT

ok I tried it's not working.

If I let the format by default my date are now 12-dec-2010

When I type 20, it will give me no answer.... When I type 19 it will select only 19 as day not year.

If I changed back the format only in text box to M/D/YYYY, it will select also only the day.

If I changed back the format only in text box to YYYY/M/D, it will select the first 2 digit of year when type 19 but if I type another number like 198, nothing is available but I do have date like 1990-10-24

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

Tue, 18 Mar 2014 11:55:36 GMT

Thanks I'm trying it!

ok it's not working

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

ashwanin — Tue, 18 Mar 2014 12:36:12 GMT

Can you post a sample file for checking

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

Tue, 18 Mar 2014 13:05:52 GMT

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

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

ashwanin — Tue, 18 Mar 2014 13:16:55 GMT

hi use this in your script :

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

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

jonathandienst — Tue, 18 Mar 2014 13:18:12 GMT

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

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

Tue, 18 Mar 2014 13:21:46 GMT

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