Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
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.
Hi Sarif,
Can you please provide the dates that you are trying to convert.
Regards,
Arpit
So Search do not work, when we have expression in List Box?
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
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:
It's working with expression also in UI. Check attached. I use this for expression -
Date(Date#(DateField,'DD-MM-YYYY'),'DD.MM.YYYY')