Input box predefinded values from date field

[seWork]

Hi all,

I'm trying to have an input field with predefined values of a date field 

by using Concat(DISTINCT date,',') in the listed values  for getting the list of dates as a drop down

but when I'm checking the variable value I'm getting the result of the formula instead

e.g

if I'm picking the date 28/06/2019

I'm getting the value 0.0023113752682846

what can I do to receive the date as a variable?

[Sammy_AK · Accepted solution]

do not input $ in front of variable, this will not evaluate the variable. for e.g.

• $(vLastWdt ) will give you the evaluated output of the expression available in variable.
• vLastWdt will give you the output of the variable expression you have entered in the variable. 

[seWork]

Thanks 

I'm sorry that i didn't explained myself well

the problem is that I'm trying to use this var in the load script 

and the var is not recognized without the $

there is a solution for it?

[seWork]

I found it

thanks (-:

https://community.qlik.com/t5/QlikView-App-Dev/Date-Variable-in-Where-clause-in-load-script/m-p/5833...