Search is no Working in List Box

[mhmmd_srf]

Hi All,

I have a list box with Expression :

=Date(Date#(DT,'YYYYMMDD'),'M/D/YYYY').

I am not able to search anything. Is there any other option to make search working?

Please help.

Thanks,

Sarif

[Anil_Babu_Samineni]

Top right corner one icon showing for search. use that. and you may remove the Always one selected value then use that. Or else it won't help

[Anonymous]

Hello Sarif,

Why you don't format your date in script directly or in variable?

And after you use our field in list box. the search option will work. 

[arpitkharkia]

Hi Sarif,

Can you please provide the dates that you are trying to convert.

Regards,

Arpit

[mhmmd_srf]

So Search do not work, when we have expression in List Box?

[mhmmd_srf]

Anil Sir,

I dont have Always One Selected Value. And I am trying to use right hand corner Search option only.

Still not working.

Please suggest.

Thanks,

Sarif

[sunny_talwar · Accepted solution]

I would fix the date in the script and that will make your life so much easier

Date(Date#(DT,'YYYYMMDD'),'M/D/YYYY') as DT

Once this is done, look at the search options here:

Dates in Set Analysis

[Anil_Babu_Samineni]

It's working with expression also in UI. Check attached. I use this for expression -

Date(Date#(DateField,'DD-MM-YYYY'),'DD.MM.YYYY')