control the display of dates in Current selection box

[ali_hijazi]

Hello

I got a datetime field

I put this field in a list box (by default this field shows as numbers but I can change the display by changing the format in the Number tab)

however if the user selects a date in the current selection box the value still appears as number

is there a way to force qlikview to show the value as date (readable)

please advise

[#2]

post sample file so we'd see the data format

[#3]

if you change it in Number tab you only change display format (but it still will be numbers)

Why don't you change it on reloaod script?

[ali_hijazi]

I already created the schema and most expressions use the comparisons based on the fact that the date is in number format

[#5 · Accepted solution]

try document properties ---> Number

and change [Your field] Number format to Data