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

[#1]

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!

[ashwanin]

Can you post a sample file for checking

[#3]

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]

hi use this in your script :

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

[jonathandienst · Accepted solution]

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

[#6]

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